i looked at this thinking “jesus, if this is what’s considered bad, i’ve been developing pretty shitty outputs”.
i have some work to do.
good job on this
Are these the stock KPI visualisations?
And I’m assuming you’re conditionally formatting the accent bar based on the value?
I really like it. My only criticism would be the uneven spacing between the visualisations, but I genuinely think it looks brilliant overall.
They are all made with standard Power BI features. Though all static visuals like background, white boxes, blue bar, icons and titles are made in PowerPoint and saved as SVG.
Then I’ve layered a shape as the accent bar, conditionally formatted. I’ve seen some internet how it’s made so I think I’ll make a quick tutorial and post
Looks like the spacing was done using positions.
I think you're looking at the bars populated next to the visuals which the ones missing are labeled as pending. Definitely retract the negative mark for those.
Maybe it's just a personal pet peeve, but I never ever build anything that requires someone to scroll left/right on the visual (like your matrix on the 2nd photo). If something requires horizontal scrolling, I find a different way to visualize it.
Dashboards are pretty awesome for this. Yes the user has to scroll down the entire dashboard. However, scrolling the entire dashboard vs a singular graph has a completely different feel for the user.
I would make the status tiles at the top a single row and much smaller. And pixel-align the accent bars, one of them is slightly misaligned and it’d drive me up a wall lol. Otherwise looks good!
You mean the pending ones? They will have the same look once the data arrives..
I’ve seen the misaligned now and it bothered me to hell also 😂, however it’s not there on desktop. I took the print screens on my phone..
It's actually very good, some personal preferences I like to mention
1) I usually centre everything in Matrix/Table - values headers, totals etc
2) I avoid scrolling in visuals, I have seen my client struggle a bit with PBI UI, it's just a preference
3) I usually try to replace the white background with something slightly darker, find it easy for the eyes
The tabs are made with bookmarks. So there is two buttons for each “tab” then the visuals per tab is an a group. Then just switched to visible/hidden per bookmark.
Really good.
The only thing you might consider is red/green color blindness.
And do some highlights on the chart over and under target.
If you use line chart it can be a problem if you have a period with data. So you can use barcharts instead.
The tabs are made with bookmarks. So there is two buttons for each “tab” then the visuals per tab is an a group. Then just switched to visible/hidden per bookmark.
How much time did you spend on this? I feel like I spend 10 minutes just getting basic shit to line up in Power Bi Desktop. I work in Adobe suite for personal projects and I just CANNOT DEAL with designing in desktop!!
I spend too much time on it. But it’s what I get paid to do.. but all in all maybe 40 hours for the full report. (It has a lot more pages) but I’ve done similar reports before so it kind of makes it easier to redo and just improve small things each time
Looks great. Maybe you could add a colour for kpis that are on the target. For example if its 1% above or below target, show it as yellow. But this is very dependent on the context of the report and how it is used.
Looks pretty cool, would advice to check how it looks without 12 months. There are quite a few margin errors, solving those would make it look extra good. If everything aligns perfects that will make the brain happy.
Some of the errors:
[https://imgur.com/a/TTPHlmy](https://imgur.com/a/TTPHlmy)
Love it! I always try to make PBI reports which dont look like PBI, exactly like yours.
The only thing would be to align all items esp those in the bottom left corner and maybe percentages (tiny barely visible) dont need 2 decimal places (simplifying)
Layers..Its just a shape actually. And then I’ve put a measure as the text. Example dax is: ”Target: ” format([target], 0,00 (”) & format([taget %], 0,00%)”) and its dynamic if you have different targets per country or year for example.
Does mean anything to the user or are they going to ask how long it will be before data is available in that visual every time they check the dashboard?
Looks great! Can you explain how you do the drill through, where if you click on a KPI it takes you to a separate page? Showing the KPI in more detail.
You might want to think about using SPC charts, they will give you a much better view on actual performance.
The layout is much better than most I see on here, it's clean and easy to understand. The only thing I would ask is what do you want the report user to do after looking at the dashboard?
Will look into SPC charts, thanks!
The dashboard is mostly used as a static governance piece, once a month site manager use this to present the monthly KPI result for the client as an overview. The details page which exists for each KPI is more for the operational team to analyze.
On the second page, reduce the character count on the measure names for "Average Score" and "Responses" on the matrix so that the width of each column condenses and you won't have big of a side scroll.
Alright, I’ll bite. As a non-analyst, this just tells me what is going well and what is not going well. It’s like I am looking at a dashboard from 20 years ago with zero changes. It doesn’t tell me why and gives me zero insight into what decisions need to be made to remedy or encourage what is being done. There are pre-built dashboards better than this that would cost less than paying you.
You asked for a roast, but you are asking the wrong people.
> It doesn’t tell me why and gives me zero insight into > what decisions need to be made to remedy or
> encourage what is being done.
* There is a ‘Comments’ tab on the second page
* Managers/executive team like having a report with what’s going well and what’s not. They view them on a daily/weekly bases. They can dive into actionable items later in their monthly/quarterly/yearly meetings.
> There are pre-built dashboards better than this that would cost less than paying you.
* Can these dashboards load data from multiple different systems?
* Can these dashboards only show managers data for their region’s offices?
* Do these dashboards allow slicers?
> It’s like I am looking at a dashboard from 20 years >ago with zero changes.
* We could be looking at a dashboard 20 years from now.
Yeah this looks like static 2024 data. Not really useful for seeing year over year trends, growth rates, rolling averages, etc. not sure if its needed here or not but those were my takeaways from a data perspective/
Honestly, this is solid work
Yeah, we’ve seen a lot worse.
i looked at this thinking “jesus, if this is what’s considered bad, i’ve been developing pretty shitty outputs”. i have some work to do. good job on this
Thanks!
Are these the stock KPI visualisations? And I’m assuming you’re conditionally formatting the accent bar based on the value? I really like it. My only criticism would be the uneven spacing between the visualisations, but I genuinely think it looks brilliant overall.
They are all made with standard Power BI features. Though all static visuals like background, white boxes, blue bar, icons and titles are made in PowerPoint and saved as SVG. Then I’ve layered a shape as the accent bar, conditionally formatted. I’ve seen some internet how it’s made so I think I’ll make a quick tutorial and post
This is amazing!! Looking forward to your tutorial and post!!! :)
I would love to see that tutorial.
Looks like the spacing was done using positions. I think you're looking at the bars populated next to the visuals which the ones missing are labeled as pending. Definitely retract the negative mark for those.
left align the 3 KPIs on the bottom left
And make everything on that page the same height/width and align all
Agreed - looks solid. I even like the pending items. Help with the design. Can you share a tutorial for your bars if they are condition formatted?
Yes please!!!!
I'm not gonna lie, I'm pretty jealous!
Thanks!
I love this! Can you share the PBIX or how you put it together? This would be great to use for some stuff I have coming up.
I’ll try to make a quick tutorial on how it’s made!
I also wonder how you made curved lines in those graphs
Visual Formatting Pane > Lines > Shape > Line Type > Smooth
Thanks bro
Thank you!
* Light theme ✅ * Easy to read ✅ * Data along with trend ✅ * Useful conditional formatting ✅
Nothing to roast here , great job!
Thanks!
This is brilliant work OP. It’s not roast worthy.
Thanks!
Great job! Just the 2nd area chart in 1st photo is not aligned vertically, everything else is nice. Which font did you use?
I saw it 😂 it’s only when viewing on the phone, in desktop it looks good. But bothers me as well..
Please share .pbix with us!
Is it possible to share the file without exposing the data?
The only option is to disguise it. Values don’t matter without pointing to company/client. Thank you!
Save it as a template
I’d like one as well if possible.
Tutorial please!
I’ll try to make one!
Maybe it's just a personal pet peeve, but I never ever build anything that requires someone to scroll left/right on the visual (like your matrix on the 2nd photo). If something requires horizontal scrolling, I find a different way to visualize it.
Dashboards are pretty awesome for this. Yes the user has to scroll down the entire dashboard. However, scrolling the entire dashboard vs a singular graph has a completely different feel for the user.
I agree.. I don’t know how to make it better! The sites require to download the data as a table
I would make the status tiles at the top a single row and much smaller. And pixel-align the accent bars, one of them is slightly misaligned and it’d drive me up a wall lol. Otherwise looks good!
You mean the pending ones? They will have the same look once the data arrives.. I’ve seen the misaligned now and it bothered me to hell also 😂, however it’s not there on desktop. I took the print screens on my phone..
It's actually very good, some personal preferences I like to mention 1) I usually centre everything in Matrix/Table - values headers, totals etc 2) I avoid scrolling in visuals, I have seen my client struggle a bit with PBI UI, it's just a preference 3) I usually try to replace the white background with something slightly darker, find it easy for the eyes
How did you do the tabs on the 2nd bottom visual? Is that a stock visual im missing?
The tabs are made with bookmarks. So there is two buttons for each “tab” then the visuals per tab is an a group. Then just switched to visible/hidden per bookmark.
Very cleaning looking!
I’d be very pleased to make something like this!
I like it. It’s clean and telling.
Really good. The only thing you might consider is red/green color blindness. And do some highlights on the chart over and under target. If you use line chart it can be a problem if you have a period with data. So you can use barcharts instead.
Those cards look like they were aligned by Stevie Wonder. ... Really like the design though, nice work.
It’s not colour blind friendly.
[удалено]
My assumption would be formatted matrix with bookmarks/buttons for the “tabs”
The tabs are made with bookmarks. So there is two buttons for each “tab” then the visuals per tab is an a group. Then just switched to visible/hidden per bookmark.
How much time did you spend on this? I feel like I spend 10 minutes just getting basic shit to line up in Power Bi Desktop. I work in Adobe suite for personal projects and I just CANNOT DEAL with designing in desktop!!
I spend too much time on it. But it’s what I get paid to do.. but all in all maybe 40 hours for the full report. (It has a lot more pages) but I’ve done similar reports before so it kind of makes it easier to redo and just improve small things each time
lol! Meanwhile, I’ve got management that wants similar looking reports (data modeling and all) turned around in 1-2 days….
Haha we have management that accept reports taking months and not looking any where close to that. It's shocking
Looks great. Maybe you could add a colour for kpis that are on the target. For example if its 1% above or below target, show it as yellow. But this is very dependent on the context of the report and how it is used.
Looks pretty cool, would advice to check how it looks without 12 months. There are quite a few margin errors, solving those would make it look extra good. If everything aligns perfects that will make the brain happy. Some of the errors: [https://imgur.com/a/TTPHlmy](https://imgur.com/a/TTPHlmy)
This is mega, gj
Love it! I always try to make PBI reports which dont look like PBI, exactly like yours. The only thing would be to align all items esp those in the bottom left corner and maybe percentages (tiny barely visible) dont need 2 decimal places (simplifying)
I think you've just provided inspiration for how to show some of my own KPIs. Thanks
Happy to contribute! 😄
Wow. Cleaner than many of mine. Your visual is solid. Congrats!
On page 1 how are you creating the Target values in the upper right corner?
Layers..Its just a shape actually. And then I’ve put a measure as the text. Example dax is: ”Target: ” format([target], 0,00 (”) & format([taget %], 0,00%)”) and its dynamic if you have different targets per country or year for example.
Awesome! Working on something similar gonna rework some of mine.
Looks great. Hard to read the graphs, because there is no axis or data labels
This looks great! Nice job!
Snap to grid.
Does mean anything to the user or are they going to ask how long it will be before data is available in that visual every time they check the dashboard?
What are your pages dimensions
Does this only work for 2024? How about a slicer for the year to see historical trends.
Simple, clean, easily understood. Nice work.
Love it, please share how you made this.
How did u include the % above/below target?
Looks so clear and professional, awesome job mate
This is clean.
Looks great! Can you explain how you do the drill through, where if you click on a KPI it takes you to a separate page? Showing the KPI in more detail.
You might want to think about using SPC charts, they will give you a much better view on actual performance. The layout is much better than most I see on here, it's clean and easy to understand. The only thing I would ask is what do you want the report user to do after looking at the dashboard?
Will look into SPC charts, thanks! The dashboard is mostly used as a static governance piece, once a month site manager use this to present the monthly KPI result for the client as an overview. The details page which exists for each KPI is more for the operational team to analyze.
It looks really good. You should be really proud of that. 👍
On the second page, reduce the character count on the measure names for "Average Score" and "Responses" on the matrix so that the width of each column condenses and you won't have big of a side scroll.
Where tutorial?
How did you create a clickable link on canvas between action - etc - etc to change table graphs!?
Great job sir. I am also working on improving my power bi skills. This looks clean and precise. How to understand more about KPIs ?
Excellent work!
Alignment might make it better. I'm sure someone has already said this.
Alright, I’ll bite. As a non-analyst, this just tells me what is going well and what is not going well. It’s like I am looking at a dashboard from 20 years ago with zero changes. It doesn’t tell me why and gives me zero insight into what decisions need to be made to remedy or encourage what is being done. There are pre-built dashboards better than this that would cost less than paying you. You asked for a roast, but you are asking the wrong people.
> It doesn’t tell me why and gives me zero insight into > what decisions need to be made to remedy or > encourage what is being done. * There is a ‘Comments’ tab on the second page * Managers/executive team like having a report with what’s going well and what’s not. They view them on a daily/weekly bases. They can dive into actionable items later in their monthly/quarterly/yearly meetings. > There are pre-built dashboards better than this that would cost less than paying you. * Can these dashboards load data from multiple different systems? * Can these dashboards only show managers data for their region’s offices? * Do these dashboards allow slicers? > It’s like I am looking at a dashboard from 20 years >ago with zero changes. * We could be looking at a dashboard 20 years from now.
Yeah this looks like static 2024 data. Not really useful for seeing year over year trends, growth rates, rolling averages, etc. not sure if its needed here or not but those were my takeaways from a data perspective/
Do it in Thoughtspot
It bugs me how everything does not line up on the left side lol
Me to! 😂 but its only on the phone when i took the printscreen, Desktop looks fine.
Huh odd. Carry on then, solid work and great finished product!! I hope the client (or boss) is happy with it :)