Insane Power BI Dashboard Design with Figma | Timelapse

This is a timelapse of a Power BI dashboard design makeover. I change an old sales dashboard I built in the past. I build the background design with Figma.
It was a lot of fun to make this video.
You can find the tutorial for the full report here:
• Power BI Design Tutori...
📸 IG: / yourownkpi
🖼️ Dribbble: dribbble.com/YourOwnKPI
👨‍💼 LinkedIn: / zsolt-szabo-bln
Timestamps
00:00 Intro
00:24 Power BI I (rearrange visuals)
01:37 Figma I (background design)
05:01 Power BI II (import background)
09:17 Figma II (filter pane design)
10:26 Power BI III (import filter pane)
11:33 Finished Dashboard
Music
1. Ian Post - Beyond (0.00)
2. ANBR - Rain (4.39)
3. ANBR - Seasons (6.54)
4. The David Roye Collective - Eternity Awaits (10.17)
#yourownkpi #yokpi

[@yourownkpi]

Here is the step-by-step tutorial for the report. Enjoy! kzbin.info/www/bejne/iISVfH9secxpg9U

[@kobe6978]

This is insane. Please keep on making these videos. They're highly appreciated

[@kobe6978]

Also you're not getting enough views for the value you provide

[@yourownkpi]

Thanks, more to come :D

[@koushikraj9815]

@@yourownkpi can you make video how you make with explanation. i wan to make custom background like yours. I laso have question is DAX/formula writing necessary?. i don't have experiance, so please make detailed video from picked 1 project as an example from begin to end.

[@moddysharji5798]

Please share the background

[@JackOfTrades12]

Looks great until the customer says "Can we add a visual here?"

[@TheCollapsedPsi]

"Can I download the raw data to import into excel?"

[@nikhil1888]

I can relate😂

[@yourownkpi]

Can happen haha. But it's not that hard to adjust the elements in Figma for a new visual.

[@sebasantelmo]

Or when they said... can you make a raw data in order to download and make my own report 😂😂😂. Excelent and beautiful works !!!

[@toulasantha]

😂 True

[@maiaguelo23]

This is fantastic! I'm in awe of the overall design, the music and the presentation. Well done! 😊

[@yourownkpi]

thanks :D

[@nikokatsantonis1664]

This is awesome. Exactly what role I play as well, so inspiring. I've been exploring a lot around Geo Maps in PowerBi and making those look good as well. It tough but super super next level. Excited to maybe see if you get into that!!

[@yourownkpi]

Amazing. I imagine a lot goes into geo maps. I'm not familiar with them but I definitely want to look into it. Do you share somewhere your work?

[@FoxProLN]

That is impressive, keep up the great work. Please continue making these type of videos. Appreciate you.

[@mirelafernandez7593]

A criatividade e classe é incrível, uau.

[@kdausu90]

Wow, some really talented people in this world. Beautiful work!

[@joaocorreia1515]

I thought I was good at Dataviz until I saw this video. I'm going to watch all your videos and learn more, I just watched your 4 hour video and I'm already studying how to use Notion. In other words, in one afternoon I already learned incredible techniques with your videos, I want to express my gratitude.

[@yourownkpi]

Thats awesome and I love Notion. I literally run my life with it :D

[@helenhosseini1699]

I love the background music besides the tutorial you've made, it's freaking awesome

[@poweraegg]

Very nice! I have been working with a UX designer recently via Figma and the results are on a next level!

[@yourownkpi]

Awesome. Was it hard to commmunicate your needs without the person knowing Power BI?

[@poweraegg]

@@yourownkpi actually the UX designer was really talented and we came up with great clean designs. Brought the reports to the next level 😊

[@julienbaneux9723]

Where science meets art... I'm in love with both the concept and execution.

[@rochagabriel18]

I can't even imagine something like this!! Thanks for sharing this amazing work! Won a brazilian subscriber.

[@yourownkpi]

thanks :D I appreciate it

[@abel9]

Incredible and inspiring dashboard, made by a genius! Great work, you're absolutely good

[@yourownkpi]

Thanks 😅

[@horaciorios6002]

THIS IS BEAUTIFUL!

[@jaimevarelarincon]

Great job, really inspiring!

[@yourownkpi]

thanks :)

[@JohnSmith-rx2uv]

Beautiful work.

[@sahiladya8473]

Beautiful 😍

[@ranour2108]

This is amazing!!

[@stobiasd]

No dejes deDon't stop surprising us, show us your art, your talent.

[@mehmetoz886]

Master piece. Great video

[@mauricioetienne3379]

AMAZING Video! Great inspiring music also! 🙌🏻

[@user-kt7hr8sx1w]

Masterful 🙌🏼

[@UnitXXVII]

I want to repeat this masterpiece at my work! You are best!

[@martiruda]

same! problem is I need to get the data right before I jump into the next dashboard haha!

[@martiruda]

beautiful!

[@tommek_bc]

Wonderfull!! and excellent music too!!

[@JacksonCarson]

Wow - good job!!

[@mdjahin99]

Amazing!

[@LowriderLowbro]

A masterpiece, gj bro, keep it up

[@ragc777]

The work and the songs are amazing... Thanks!

[@yourownkpi]

thanks for watching :)

[@martymcfly7652]

You're very talented. This looks amazing.

[@yourownkpi]

Thanks :)

Beautiful work :)

[@germanruiz4451]

Wow, It's beatiful!

[@susandeep]

Awesome video....thx....btw nice music

[@thomaskeefe9662]

Awesome Video!

[@sickoffposers]

Rarely subscribe to anything from just a first video.. Clicked that button so fast. Great great job.

[@yourownkpi]

haha thanks :D

[@abhinavshankar92]

This is the best design I will ever see ❤❤❤

[@samuelcoelho3598]

The definition of modern art has been successfully updated.

[@yourownkpi]

thanks :D

[@tomipedelaborde]

Awesome work mate 👏

[@yourownkpi]

Thanks :)

[@oblivion3331]

Ur so handsome tomipedelaborde

[@IarukaSkYouk]

just 1 min into vid I already subscribed.... you're very good and I'm learning alot from you thank brother!!!!!!!

[@yourownkpi]

thats great thanks :)

[@InfoMgmtReportLFO]

FASCINATING

[@Obizzy8]

Clean! 😎

[@datactive859]

what a masterpiece! I particularly love the music you chose. The dashboard is just as epic as the music sounds. I am not a quick Figma user and am used to editing the background with SVG generated from PPT. Would you please tell me more about the benefit you have gained from Figma instead of PPT SVG?

[@yourownkpi]

Haha thanks. I think Powerpoint is also good but Figma is more versatile for design. I have more options with it. When I do design in Powerpoint it just feels a bit flat in comparison. Besides I work with shortcuts in Figma which makes it quick and its also fun :D

[@datactive859]

@@yourownkpi recently I found problems in ppt svg. When I generate svg from ppt slide, there is always some differences between slides ans svgs. I am not able to figure it out. So I think I have to turn to figma too.

[@yourownkpi]

once you turn to figma, you will never look back

[@williamsbaster1843]

Awesome

[@erinfield1943]

Wow you are so gifted! This is both sides of the brain hard at work. I like this style, as well as Alice's from Discover EI. Also Bas from How to Power BI makes great designs.

[@yourownkpi]

Haha thanks, that's what I love about Power BI. You can be analytical and creative at the same time. The videos from Bas are awesome. I didn't find a channel called Discover EI though

[@shivanandraskonda4670]

Awesome you're using midjourney as a reference. Boost UI/UX point of view. Nice video.🚀

[@yourownkpi]

Yes the inspiration is coming from midjourney pics :)

[@ernandesjunior1928]

Congrats from Brasil... awesome video.

[@willosullivan1986]

Cool, nice

impressive. I'm subscribing now

[@yourownkpi]

Welcome aboard

[@aviansnow]

You earned a new sub

[@jacheto]

This is beautiful, congratulations for the work. The only problem I see is that the reality of building dashboards is that it's usually an iterative process, so putting this effort in making this background in Figma is definitely not the best idea if you're doing the initial versions.

[@yourownkpi]

Thanks! You are right about that. Figma Design should definitely be the last step. I personally dont bother much with it until the visuals and the layout are already established. And when you are doing the design it's kind of iterative in itself, and you might discover things how the visuals could work better. Then you adjust. So yeah, it comes with a price :)

[@SirTupsAlot]

Incredible work. Thanks for sharing!

[@ArKeTiCt]

I Love the incorporation of external tools such figma or illustrator to achieve a design of such elegant reports, the only problem is it is not really practical on a Report that keeps constantly getting updated with new visuals or sheets. It quickly gets time consuming and instead of making the job done it really emphasizes beauty over function. Sure it hella looks nice but if i can't edit changes in a timely manner it would frustrate the actual users of this report because of delays. But hell of a nice job though.

[@yourownkpi]

Thanks and yes that's something to keep in mind. If there are a lot of incremental changes expected then I wouldn't do it either or only at the very end. However it's possible to build an entire design system in Figma, which allows you to make changes very quickly by using toggles (colors, button icons/shapes, effects like highlights or shadows etc). I will make some videos about it in the future.

[@chrisarets2231]

Very nice and good looking dashboard! Do you have any experience with how this kind of custom graphical layouts will render on say a tablet or mobile ?

[@yourownkpi]

I only did it for PC so far, so I don't know. And you need to build a new layout for mobile canvas size.

[@manendraguntamukkala1765]

I was blown away by design. It really looks awesome, and the way you used the colors and gradients is fantastic. Quick question: how long did it take you to create the entire dashboard along with the Power BI calculations and design in Figma and implement it back to PBI ?

[@yourownkpi]

Thanks :) It's hard to say, because it was the redesign of an existing report and in this video I only do it for one page. The calculations and the layout were already done. I needed a few extra measures for the new design though. On the whole 3-page report I spent around 15 hours. It includes coming up with the idea, prototyping, creating the final design, importing it to power bi and adjusting the layout, and creating 1-2 new calculations.

[@InsightLab1]

PERFECT!!!!!!!!!!!!!!!!!!!!🥰

[@nattawittommy]

This somewhat miracle for me. respect

[@yourownkpi]

wow thanks

[@enzoborjas828]

Que belleza de dashboard por DIOOOOOS

[@tayfuny3441]

Artwork!

[@riddhishah9233]

When are you posting full video of report creation as well as design ? Really looking forward to it !!

[@yourownkpi]

Here you go :) kzbin.info/www/bejne/iISVfH9secxpg9U

[@morinho96]

You're an artist

[@yourownkpi]

haha thanks :)

[@datmesay]

that's art

[@conghau7068]

so proficient, awesome...

[@yourownkpi]

Thanks a lot!

[@victorraulcandia961]

Hi @yourownkpi, excellent job on your contents, they are amazing. One query how did you do that in a filter image between several segmentations that appears and disappears? In minute 11:40 you show it. Could you make a video of that? Again excellent content.

[@MikeThompson918]

This is using the bookmarks feature. Guy in a Cube has a great video on this over at his channel. kzbin.info/www/bejne/rqqcn6CJhsqIjck

[@victorraulcandia961]

@@MikeThompson918 Thank you very much for the recommendation. It is nice to learn about new skills.

[@1Chitus]

Que excelente informe, puedes compartirme el dataset que usaste, por favor! Saludos desde Perú

[@tawesome]

That looks intimidatingly comprehensive and impressive. It's also sold me on the idea of attempting to learn it. Do you have any book or course recommendations?

[@yourownkpi]

I learned from tutorials online. I also made a short tutorial specifically for Power BI. kzbin.info/www/bejne/pIfRm2V5Ysafnqc

[@ezrarichard]

WOW!!!

[@neclis7777]

This is pretty epic with the dark colors and the music ... How long did you need irl ? Thanks for sharing !

[@yourownkpi]

Thanks, I needed around 15 hours

[@neclis7777]

@@yourownkpi Wow. Seems short for such a clean result! Thanks man.

[@JohnOttoKnoke]

This video is mind-blowing to watch. Unfortunately, it was too fast to learn all the incredible tricks of design. Can you share with us the pbix file please? You are a wizard!

[@yourownkpi]

Thanks :D Im working on a whole tutorial for this. I will share it there

[@pectenmaximus231]

Adjust the video speed in the settings

[@uzeyirktk6732]

BOOOM💣.........💥💥💥👌

[@BlackDragon-gd6io]

Nice mahn. Appreciate that work. How long did it take to complete this?

[@yourownkpi]

Thanks man. Around 15 hours

[@panxoxfcc]

Hello, excellent video! I just have one question for you or anyone who can help me. How can you make filters persist across bookmark changes? I noticed you have a filter panel, but when you activate it and switch to another bookmark, do those filters stay applied? How is that achieved? Anyway, great video! It's truly inspiring.

[@yourownkpi]

Thanks, yes they stay activated. When you create a bookmark, make sure that the Data is unchecked (when you right-click it) so it doesn't save the current filters on the visuals. Probably when you saved your bookmark with the filter panel hidden, no filter was selected and the Data was checked. So whenever you click the bookmark, it brings back every filters to that state you saved them in.

[@sajjadqureshi4536]

Damn! 🖤

[@segunijifisayo1091]

@Your own KPI, Thanks for the tutor.

[@MuhammadAhmed-wk4zh]

Thank you for makinh this. Request: Can you make your all videos without Timelapse. It will be very easy for us to watch in a smooth way just like other youtube videos.

[@yourownkpi]

yes, Im working on a tutorial for this

[@MuhammadAhmed-wk4zh]

@@yourownkpi Thank you I'm looking forward to seeing that.

[@bitokay147]

What would this be used for within a project management job ? Will it sync with the data from excel reports ?

[@yourownkpi]

Yes you can connect Power BI to many different sources such as excel, salesforce, google analytics etc. In this video the data comes from access.

[@inearplays]

This is great. But I have question (I'm new to BI). What will you do if your boss ask for enhancement and it will affect your visuals positioning. Does that mean you will re do the everything?

[@yourownkpi]

Good question. If it's only the positiong that's not a big issue. I can just go back to Figma and position the elements accordingly. It goes fairly quickly, mostly with selecting elements and dragging them around. Then I import the new background back into Power BI. But that's something to take into consideration for sure. Every adjustment will take longer than if you had only used native design elements of Power BI. The more complex something is, the more time it takes to create and adjust it.

[@inearplays]

@@yourownkpi Thank you!

[@user-ts9zi5bb1l]

This is great work! Can you please briefly describe how you made the opening filter panel? The video moves very quickly even at slow speed, I only managed to notice that bookmarks are used. This solution would help me a lot in working with filters and tables, a very convenient solution, because sometimes SWITCH does not give the desired result for the user. Matrix visualization does not allow you to put measures in rows...

[@yourownkpi]

I use an "open", "close" and "reset" bookmark. The "open" and "close" bookmarks affect the 'display' of the 'selected visuals' (I select the filter panel visual group) in the two different states where I hide or show the group. The "reset" bookmark affects the 'data' of the 'selected visuals' and I save it in a state where all the selected visuals (the slicers in the grouped filter panel) are in their inactive state. I created a tutorial for this report with more details on the filter panel: kzbin.info/www/bejne/iISVfH9secxpg9U And my next video is actually dedicated for this kind of filter panel and how to build it. I'm going to publish it next week.

[@DataDrivenOrgUk]

Hi, great video! Could you possibly do a video on the slicer menu, how you used the icons to hide them and bring them out. Please! Thank you!

[@yourownkpi]

hey thanks! I show it in the tutorial video kzbin.info/www/bejne/iISVfH9secxpg9U

[@Jmrr14]

I would love if you had a course about Figma for Power BI

[@yourownkpi]

I made one which you can find here: kzbin.info/www/bejne/pIfRm2V5Ysafnqc I plan to do soon a more comprehensive course however.

[@lijunchen]

This is awesome! I have never heard of Figma before. Is it possible to do this with Power Point? Can the free version of Figma accomplish what you have done?

[@yourownkpi]

Thanks! I don't think that you can do it in Power Point to this detail with the lights and shadows. Yes, I'm using the free version :)

[@aziztukubaev1693]

Wow, today I've decided to start learning PowerBI and looked for youtube videos and found this. Can you share your PowerBI template? ))

[@alissonamegle964]

Só faltou vc deixar a gente baixar esse background

[@Sitius86]

Incredible work! And then when you publish your masterpiece the first comment you'll get, "can I get this in Excel instead" 😭

[@yourownkpi]

Exactly 😂

[@lukassteindl1914]

nice, how much time did this dashboard took in realtime?

[@yourownkpi]

Thanks. It took me around 15 hours with coming up with the idea, prototyping and implementing it

[@jacobddavis5916]

bro im good with measures and the other M,DAX and python stuff. But my designs sucks. any tips? Btw, amazing video! do u have any course or tutorials?

[@yourownkpi]

I would start with reading the book Storytelling with Data by Cole Nussbaumer Knaflic. If you are interested in Figma, any youtube tutorial will do. I also made one specifically for Power BI. kzbin.info/www/bejne/pIfRm2V5Ysafnqc

[@gabrielcardosoft]

what app do you use to capture the element color?

[@yourownkpi]

I use microsoft colorpicker from the PowerToys bundle. you can download it for free from the microsoft store (look for PowerToys)

[@alfredtubale790]

Wow....

[@krushnachChandra]

how do you record these videos which windows capture software?

[@yourownkpi]

OBS

[@baw5xc333]

I’m going to be doing exclusive power bi dashboard development at a new job. Considering getting a super widescreen monitor. Good or bad idea?

[@yourownkpi]

I never used one so can't tell. I don't know how Power BI renders on it. I use two 27" monitors.

[@baw5xc333]

Thanks for the response!

[@premcst]

Thats Insane !! by the way Iam scared abt the amt of rework it might involve if my stakeholder just asks to include few more tabs/ Toggles for sub category and city in the report ..

[@yourownkpi]

It will take more work than it normally would with Power BI native visuals, but not by much I think. If it's just a different positioning, you can quickly adjust the shapes in Figma with your mouse. If it's the buttons and bookmakrs, it's a bit of a hassle. But it's a hassle even without Figma. That's something to keep in mind for sure

[@pectenmaximus231]

I need to rewatch to understand something better. I have the issue that if I have a slicer panel that can be hidden, then they stop being applied to the visual as soon as the panel is hidden again, ie the visual reverts to how it was before unhiding the slicer panel. I guess there must be some settings to make the slicers persist, or edit slicer interactions or something?

[@yourownkpi]

It happens, because your bookmark goes back to a fixed state for all your visuals. When you create the bookmarks for your close and reset buttons, you need to apply this only to the selected visuals (in this case the filter pane you created). How I do it is that I group everything in the filter pane and select it in the selection pane (this is my selected visual now). Then I right-click on the book-mark and mark apply to selected visuals. Then I right-click the bookmark again (while my filter pane is still selected) and click on update.

[@pectenmaximus231]

@@yourownkpi ah that is such useful knowledge. Thank you!

[@idancalif5777]

any chance you can share the background you made? fantsctic :)

[@yourownkpi]

late reply but you can download the report file from the description of this tutorial: kzbin.info/www/bejne/iISVfH9secxpg9U

[@user-dc6lt6bh8q]

Hi, great vizualization, do you propose a 'json' file for this presentation? thank you

[@yourownkpi]

Hey there is no json directly but there is a tutorial for this report here: kzbin.info/www/bejne/iISVfH9secxpg9U If you download the file through the link in the description, you can save the theme from it as a json.

[@neil78]

Is it safe to say that to design for Power Bi using Figma, first you have to have a very solid understanding of the limitations of Power Bi from a design perspective to understand to make sure you aren't designing something that can't easily be achieved? Or do you feel it's flexible enough that you don't have to design with specific limitations in mind in Figma?

[@yourownkpi]

Nah I you are good to go. The only way to learn the limitations is by trial and error. You want to build something in Figma then you see whether you can use it for Power BI or not. You discover most of the limitations when you try to import something in Power BI from Figma and it just doesnt look the same.

[@yourimenlibar5879]

Looks amazing. However i wonder if in most projects the customer wants to pay for so many extra hours. And imagine having to change the dashboard... All those background imaging needs to be redone.😮

[@yourownkpi]

Yes you might have to sell to the customer on the design part a bit harder :) And changing the background doesn't take that long actually. You can do it with simple mouse dragging and copying once you have the basic design elements. It will be more work, than if you would only use Power Bi design of course.

[@asylzhanyerzhanov3113]

well done, can u share this for study?

[@yourownkpi]

thanks! check my channel. I made a tutorial of this dashboard

[@lucascardozo5496]

Masterpiece! just a fact, what happens when the client says: oops... i need a new kpi. I have to resize everything.

[@yourownkpi]

haha that's true

[@M_AGraphics777]

+1 sub

[@avaishdhanshe7650]

how to create a Filter pop out like that, please share resource or link

[@yourownkpi]

Im creating a tutorial and I will share the link there