Visual to display multiple categories with an overall compliance percent

[tomperro]

I am looking for a visual that can display a wide range of categories (24 total) along with an overall compliance percent. 

I have 3 systems that I want to compare the count of each systems events versus a 4th systems overall compliance. 

The 4 systems have the same categorization. 

I currently have a clustered bar chart with the bars representing the count of events for each system, by category and then I am using a line to show the compliance percent from the 4th system.  My problem is that I can not fit all 24 categories on screen, which I would like to do. Is there a better way of showing this?

[freginier · Accepted solution]

Hey there!

Have you tried a heat map? If the goal is comparison, a heatmap can color-code compliance levels across systems and categories.

You could also try a Trellis (Matrix Table with Conditional Formatting). Instead of bars, you can use a matrix table to display the event counts for each system per category and use color coding to highlight compliance percentages.

Hopefully this helps!😁😁

[freginier · Accepted solution]

Hey there!

Have you tried a heat map? If the goal is comparison, a heatmap can color-code compliance levels across systems and categories.

You could also try a Trellis (Matrix Table with Conditional Formatting). Instead of bars, you can use a matrix table to display the event counts for each system per category and use color coding to highlight compliance percentages.

Hopefully this helps!😁😁

[tomperro]

I like the idea of the heat map. How would I set that up?

[Ritaf1983 · Accepted solution]

Hi @tomperro 
Take a look at my blog post, it includes pbix with the example :
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/When-to-Use-Heatmaps-and-How-to-Im...

+
Take a look at the linked guide:
https://www.youtube.com/watch?v=1olBMLi_SJ0

Please consider Accepting it as the solution to help the other members find it more quickly