cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PBI-Dash
New Member

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):

PBIDash_0-1642414818833.png


Here's how each box is today. With every box being two cards placed on each-other (two measures):

PBIDash_1-1642415570009.png

 

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

1 ACCEPTED SOLUTION
amitchandak
Super User
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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

View solution in original post

3 REPLIES 3
V-lianl-msft
Community Support
Community 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.

ALLUREAN
Super User
Super User

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




Did I answer your question? Mark my post as a solution!


https://allure-analytics.com/
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/

Proud to be a Super User!




amitchandak
Super User
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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!