Forum Discussion
Design layout for many KPI's on one sheet
Hi,
I'm in need of help regarding design issues for a report I'm asked to improve/further develop. The design isn't very scalable today. And it's getting tricky with new markets/countries incoming.
It's a survey-report that shows NPS (net promoter score) for different surveys and countries. Everything is a different object:
- The countries and survey-titles are different text boxes
- Each NPS/survey score is a card - measure
- Each # of responses is a card (placed below the NPS score) - measure
The design is something like this today (I only filled in some data points):
Here's how each box is today. With every box being two cards placed on each-other (two measures):
As you can tell the report isn't very optimized. The sheet has ~200 objects and isn't scalable at all. Every time a new country/survey was added they needed to do some manual work to fix the layout. And now with even more countries and surveys incoming, they're in need of help.
Is there a better way to do this, but still maintaining the "nice looks"? I know that I can make a Table or Matrix, but it isn't very "pleasing" for the eye. That's what they said, not my words. And I can't show the # of responses in a Table or Matrix for each NPS, can I?
They would like to show what they're showing today: NPS score and # of responses for each survey and country. They are open to the layout being transposed if needed. Is it possible?
Thanks in advance,
Sincerely
PBI-Dash , Create a measure with these two values
measure = [NPS] & unichar(10) & [Measure 2]
And use that in matrix. Use conditional formatting to color each column
Color = Switch( True() ,
[NPS] > 75, "Green"
// Add other conditions
"Red"
)
Use it in conditional formatting using field value option
4 Replies
- amitchandak
Super User
PBI-Dash , Create a measure with these two values
measure = [NPS] & unichar(10) & [Measure 2]
And use that in matrix. Use conditional formatting to color each column
Color = Switch( True() ,
[NPS] > 75, "Green"
// Add other conditions
"Red"
)
Use it in conditional formatting using field value option
- ALLUREAN
Solution Sage
Hi, PBI-Dash
You will get a performance issue with so many objects on the page. You can try something like this also:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380818?tab=overview
The second value can be added in tooltip
V-lianl-msftCommunity Support
Hi PBI-Dash ,
Maybe you can try using matrix KPI visual to see if this visual can help you:https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381299?tab=overview
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.You’ve hit the “200-objects” trap. Fix it by making metrics switchable instead of duplicating visuals: use a Field Parameter so one KPI card flips between NPS/Responses, move Responses to a subtitle or tooltip, and show Country × Survey in a matrix or small multiples with conditional formatting. Keep a simple grid and use drillthrough for country detail instead of cloning pages. I wireframe this flow in Mokkup.ai first. The existing dashboard templates + drag-and-drop keep spacing consistent, and the export to Power BI file saves a ton of rebuild time.
