Power BI Design Tutorial with Figma | AI Inspired Dashboards

[@marianovizzo]

You're the Messi of Power BI! 💯 I just found your videos and they are fantastic.😎 You transform science into art. Please continue to create these videos. 🙏 Thanks!! 🙌

[@yourownkpi]

Wow Thanks! These kind of comments motivate me to do more videos.

[@dominikspieler5308]

omg just found you and have to say thank you so much. Not only a fast video of creation, but also a tutorial AND downloadable file. You truly understand how to provide value

[@yourownkpi]

Haha youre welcome :) more to come

[@Gonza2432]

I love this dashboard. I need to learn Figma!

[@mnedix]

Thank you for this, it really helps making the PowerBI dashboards more appealing. While it's not easy to get to your level, I'm sure I'll get there given enough time to practice.

[@yourownkpi]

Youre welcome. I'm also still learning this stuff and I think you can have above average design skills (among power bi developers) in a fairly short time. The bar is not too high haha. Of course to become an expert takes years, Im also not even close. But it's also not necessary for creating awesome dashboards.

[@thanh-liemle7704]

May I ask if you have a separate tutorial for the measures created in the report? That would be GREAT help. I would love to see more details of how the measures were calculated.

[@yourownkpi]

no separate tutorial for the measures unfortunately 🙃

[@davidkamqwerty2346]

Started using figma after watching your videos, and even I can't believe the dashboard UI I'm creating now. My power bi reports look out of this world unreal.. Thanks for the videos. Please create more of this great content👍👍👍

[@lol51545]

me too!

[@yourownkpi]

thats great, yeah more to come :)

[@nicemovies99]

Thank you so much for this awesome tutorial! Wish for more in the feature.

[@yourownkpi]

thanks :) Was it easy to follow? I plan to do similar videos in this narrative style.

[@nicemovies99]

@@yourownkpi It was absolutely easy to follow, looking forward to more videos to come!

[@yourownkpi]

Thanks, more to come :)

[@joshamass5197]

Please keep up with the content, really helping me improve my work.

[@yourownkpi]

Great to hear 🙌

[@Cristian-t9i]

bro please do another video like this, you re the best

[@yourownkpi]

Im finishing up a filter panel series and after that I want to do mroe figma designs like this

[@anhlehoang8817]

thank admin

[@oumaabdi5541]

Please put the dataSet in the drive link .... The one shown is not the right one, I'd like to add it to porfolio And thank you very much for the video

[@FromPlanetZX]

how did you make the Filter option like that. All the filters in one place.

[@yourownkpi]

Its done with bookmarks

[@shahzadkheros]

Impressive

[@alvaroaguilerabalbontin1191]

The bookmark you created for the filters: can you select a filter and then close the bookmark? Because I have the feeling that if you close it, everything will be reset so the filters wouldn't be actually applied (unless the filter box stays open).

[@yourownkpi]

It works fine, the filters are still applied when you close the filter pane. Check the sample file (link in the description).

[@leonardolopezDATA]

Excelente tu trabajo! Para tus vídeos qué cámara e iluminación utilizas ? Es otro detalle destacado de tu canal

[@yourownkpi]

Thanks :) I have a sony A7C camera with a 35mm Sony objective. For the lights I use a Godox 60W led light with a 120cm Godox softbox.

[@juancho.landero1006]

Gracias !!! ❤❤❤❤

[@danilosouza8689]

O melhor

[@prashanths9023]

Hi buddy can you please provide me path where i can practice with the challenges and learn it?

[@koushikraj9815]

Just start with all yearly pays lip statement of yours and made visual and give example how your exp and salary growth happened .

[@yourownkpi]

At the beginning I learned from books. My first book was called Supercharge Power BI and it covered overall the specific areas within Power BI. Then I would focus more on one area at a time. I prefer books over video courses, because they are more comprehensive and for me it's easier to follow. After finishing a generalized book I would deep diver as follows: -Data modelling -> especially star schema, relational data models. You can google a lot of information about it. More advanced would be the book Datawarehouse Toolkit. -Visualization & Storytelling -> I highly recommend the book Storytelling with Data -DAX -> Book called The Definitive Guide to DAX. This is the holy bible of DAX, but more advanced -Power Query -> Book Master Your Data with Power Query You can also go on Google/KZbin and look for specific topics.

[@thomaskrantz8352]

Thank you so much for sharing this type of visual. This is exactly what i was looking for ! I'm a begginer in using Power BI, and this style is totally the kind of visual i like to use !

[@adolfomartin]

Wow Your dashboard looks amazing, keep it up! When you can also produce light versions. Brazilian greetings!

[@yourownkpi]

Thanks :) I will do more light versions for sure.

[@paperheader]

are the displayed data you are switching in between the "state" and "manufacturer" state in the "rating" folder pre-saved data in the form of static picture over different bookmark? or are they realtime data fetch from the data source? sorry i was skimming through and do not have time to go through the entire video.

[@yourownkpi]

Hey, no worries. They are in real-time from the data source

[@gamesgenta2978]

google sheets pls

[@SergiySydorov]

Thank you. Cool video. If you use styles and components in Figma, it will allow you to quickly make many identical elements (for example, buttons) and manage their change from the master component.

[@yourownkpi]

Thanks for the tip, I will check it out

[@tomipedelaborde]

Most aesthetic dashboard design channel, great workkk

[@yourownkpi]

Thanks!

[@QuantZero]

Download link leads to another PBIX file or am I missing something?

[@yourownkpi]

hey you are right, it was the wrong link! I changed it and here is the correct one: drive.google.com/drive/folders/1-_SyPODmVENnj2wTg3tzowqvKIwToZnt?usp=sharing

[@helenhosseini1699]

Download link is not getting open? when i go in to google drive link, nothing gets open if they are meant to!

[@yourownkpi]

The link seems to be changed for some reason. I updated it: drive.google.com/drive/folders/1btazlfgmdAFrNZq9Nr7OZfrPaoIhfNyp?usp=sharing

[@DarisDaniel]

Hi, Where can I find maps like the one you are using in the video?

[@yourownkpi]

this is a native visual in Power BI. You have to enable Shape Map i the Options/Preview Settings

[@armaqanalibabaei6980]

Thanks a lot☂️I can practice it today

[@yourownkpi]

Enjoy :) Can you give me a feedback how easy it is to follow? There is a lot of text and I kind of narrate it instead of exactly showing the steps

[@armaqanalibabaei6980]

Of course,it took me 3 hours to complete it step by step(cuz I’ve watch ur previous videos it was easy)and more importantly ur comments in some measures was impressive cuz I could understand the whole story behind ur dashboard, May I use this color and method on my project?☂️

[@yourownkpi]

Thanks for the feedback. Sure go for it :)

[@rajshekarreddy5358]

@@armaqanalibabaei6980 Can you please share the original dataset with me. Even I want to practice it.

[@guilhermefeo8381]

Congratulations on the content, I'm learning a lot from your videos. I'm trying to create a chart with productivity results only on the maximum date to achieve this visual effect with marks only on the last date with a value, but I can't seem to do it in any way.

[@zakariahaddouche2922]

phenomenal ! Great inspiration i get each time seeing one of your works ! i've been focusing on app like deigns in power BI and the clients are more engaged when the design is attractive ! Bravo !

[@helenhosseini1699]

where did you build your power BI dashboards?

[@MrLipitanga]

amazing!! congrats and tks for sharing

[@pablosaizortuno4740]

Very very good!! you are a machine! One question! do you know how to hide the page menu at the botton of the report? I am getting crazy with this PROBLEM

[@pablosaizortuno4740]

solved :) http: ... &navContentPaneEnabled=false

[@yourownkpi]

Thank! This is a problem for me too. Unfortunately I don't know of a solution :(

[@pablosaizortuno4740]

@@yourownkpi just add the code before at the end of the web Http

[@yourownkpi]

For me it's not working on report server unfortunately

[@rodrigoribeiro5495]

Very good! Elegant and sophisticated.

[@qboxricardo]

Amazing, thanks

[@hamedkalantari9589]

Fantastic !!

[@menggambarsenyum]

how do u copy PB visual into figma , i tried copy paste and nothing ha[[en

[@yourownkpi]

I made a screenshot and copied that

[@gamerzone8856]

Really like your work. You keep it really clean, simple but looks are aesthetic. Can you guide on figma tutorial for beginners to design dashboard, it would be really helpful.

[@yourownkpi]

More tutorials are about to come but as starters you can check this beginner's Figma tutorial with Power BI :) kzbin.info/www/bejne/pIfRm2V5Ysafnqc

[@ParamjitSingh-eq1ti]

Thank you.

[@successpradhan13]

Is there any way we cab export a particular visualisation as a image format? I use photoshop and I want to hage completed control over text and design and using Power BI is a huge pain for me. In tableau its available 😢

[@yourownkpi]

The only option I know of is exporting the report as pdf. I usually just make screenshots.

[@MrLipitanga]

just discovered your KZbin channel, and I'm already a huge fan of your work! Congratulations on the quality of your content and for sharing it with the community. the Figma file you shared in the video below is incredible, and I'm actually using it to create a Power BI dashboard for a close friend of mine. I've been trying really hard to create a similar panel, but with a "light" format, something like a creamy color palette, but I just can't seem to get it right... there is any easy way to do that? also, do you have any video biulding a figma for power bi mobile layout? Thank you so much!

[@yourownkpi]

Thank you. As we discussed on Instagram

[@jeffersonmedeiros1830]

Amazing! Thank u, I'll pray for u success... And sorry about the english, I'm from Brazil

[@yourownkpi]

Wow thank you :)

[@koushikraj9815]

Thank you

[@JeremyHilliker-q4c]

This is really cool and thanks for all the offerings here. Happen to know if you could make the filter dynamic? Looks like it only does the filtering on the 'Sales' section. Is there a way to create one filter dropdown option on one tab and yet another on the other tab and bring you back and forth between tabs? Can the filter options within them be different too?

[@yourownkpi]

If I understand you correctly, to switch different filters on different tabs, you need to create bookmarks. Or maybe you could use field parameters like in this video kzbin.info/www/bejne/pIjKgaykhZ6Leq8

[@CoryHenke]

Beautiful. 🤟

[@ajproductions7357]

Thank you so much for this Zsolti, probably the best visualization tutorial on KZbin. When it comes to Midjourney /imagine prompts , what keywords would you recommend for power bi dashboard examples ?

[@yourownkpi]

Wow thanks :D For the images in the video I used prompts like this: "ui design for sales dashboard, title on top, bar chart top left, bar chart top right, map visual bottom left, linechart bottom right, consistent design scheme and color scheme, light ui, ux, ui/ux" My experience was that if I leave it more vague and leave more room for the AI for interpretation, it delivered better results. This was however a couple of months ago with Midjourney v4. I think they changed Midjourney v5 so that you have to write rather in full sentences instead of just listing attributes. Also I think we need to be more specific now what we want when prompting. I'm interested in this and plan to do a video about it when I figure out something.

[@ajproductions7357]

@@yourownkpi Thank you for taking the time to reply to me !!!! You’re knowledge sharing is forever appreciated 🙏🏽!!!

[@marcioledo_]

Sensacional. Parabéns por esse belíssimo trabalho 😍😍

[@TAlshaber]

Did Figma update the data once it's updated in the source like: Excel, Database?

[@yourownkpi]

Yes it works like a regular Power BI report

[@nseworld5521]

Great job! High level visualization 🔥

[@leonardodalviason3898]

Ola, Gostei muito do Video Aprendi bastante Obrigado por compartilhar o conteúdo. Achei muito Top essa ideia de usar Ideias do AI, forte abraço do Brasil.

[@yourownkpi]

Thanks, yeah I think there is a great potential with AI yet to come.

[@ChrisRestrepo]

Simplemente brutal 💪🏼💪🏼💪🏼👊🏼👊🏼👊🏼 thanks for sharing

[@ChrisRestrepo]

where do you get those backgrounds?

[@yourownkpi]

You mean the AI generated dashboards? They are from Midjourney

[@gagansingh3481]

Hi Sir could you please make a course on it on udemy

[@yourownkpi]

On what exactly? On this dashboard or on Figma/Power BI in general?

[@shanky6703]

In the second page, YTD sales by category, the PRY is upside down. I don't know why they had it upside down in the first place. Was it intentional?

[@yourownkpi]

Where do you mean exactly? I cant see it.

[@shanky6703]

@@yourownkpi In the Sales New page, under the YTD by category - Revenue difference. Urban value for PRY is -19.8M which is not aligned with current year

[@yourownkpi]

Thanks for pointing it out, it was my mistake. The delta PRY differences werent's sorted by the revenue as the revenue bars. I updated the download file.

[@koushikraj9815]

I have question. Does multiple dashboard necessary?. Why multiple dashboard was made for what reason ?

[@yourownkpi]

Im not sure what you mean. The Sales and Ratings pages?

[@koushikraj9815]

Yes. For eg in figma all charts are in ain't dashboard right. I also learnt single dashboard. I noticed multiple dashboards are in your phi. So I asked is multiple dashboards were necessary or it was made multiple for explanation (client asked for multiple dash board). I don't have experience or worked on project. These crucial things was necessary for me.

[@yourownkpi]

I did this dashboard in school and it was my decision to show multiple dashboards. It depends on the requirements. I wanted to have one topic on one page (Sales and Units Sold numbers) and another topic on another page (Product ratings). YOu can decide whether to fit things into one dashboard with less detail or create multiple dashboards. As said, it dependd on the business needs. I usually like to have less visuals each page, so it doesnt get overcrowded and it's easier to focus on one thing at a time.

[@reselk123]

Good job, this is awesome! Can you explain how you made the chart with the predictions in 09:00? The dotted line after the marker was very interesting but I couldn't apply it even with the tips in DAX =/ Ty!!

[@florianfuchs9390]

Yes! Great work. And I am also interested in how to do the Prediction dotted line

[@yourownkpi]

The dotted line is the PRY YTG (Previous Year - Year to Go) and it's actually the full previous year ignoring the date filters ALL(dDate).

[@reselk123]

@@yourownkpi That's it, but how did you do it?

[@reselk123]

Which dax did you was used to get the forecast/previous year?

[@olajosmihaly]

Very cool. Good job!😉👍

[@yourownkpi]

köszi :D

[@ehsaneisa174]

You are the best ❤🎉

[@yourownkpi]

Trying to be the best version of me :D

[@elecirlisboa9155]

Excelente vídeo, parabéns!!

[@svillegaz]

Thanks for this video. I feel that I learnt tons of skills in 34 minutes The things I learnt - How to get inspiration - Design: Backgrounds, shadows, lights, masks, gradients - That space for the buttons 🔥🔥 - Have your color palette and just pick up the colors from there with the dropper - Some power bi stuff I didn't know it was possible like replacing the button backgrounds with your buttons from figma

[@yourownkpi]

Thats awesome, I plan to do more videos like his very soon