Design layout for many KPI's on one sheet

[PBI-Dash]

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

[V-lianl-msft]

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.

[ALLUREAN]

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

[amitchandak · Accepted solution]

@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