Top N Percent Matrix Visual

[RLSid17]

Hi,

I'm trying to make a matrix visual showing the Top 3 percentages. I already have a matrix report but I wanted it to show the top 3 that are favorable and the Top 3 that are unfavorable:

So the columns are rows and they count each response to show the percentage of the row total as shown above. Is there a way for it to show the Top 3? For example, there are 3 categories that are at 100%, and basically just want to show the Top 3 Favorable. Also the same as unfavorable.

[Anonymous]

Hi @RLSid17 ,

Check the "show items with no data" feature.

Show items with no data in Power BI - Power BI | Microsoft Learn

Best Regards,

Jay

[amitchandak]

@RLSid17 , for TOP you can try TOPN function

example

CALCULATE([Net], TOPN(3,ALLSELECTED('Item'[Category]), [Net],DESC), values('Item'[Category]))

TOPN: https://youtu.be/QIVEFp-QiOk

For Top % , Try like

https://exceleratorbi.com.au/pareto-analysis-in-power-bi/

[RLSid17]

I tried Top N but it doesn't show the results I'm expecting and I'm not sure if the Pareto Analysis would fit in.

Basically, the requirement would be like this, this is the visual I have:

And they would like for it to be like this in a separate visual (I know it may seem that I have already done it but this is only filtered, they would want for it to automatically get the percentage from the 1st visual:

So for example, all 3 above only has Favorable responses. They would also want it to get Unfavorable responses. So basically if 2 out of 3 column rows are blank, that would only get the value.

Please let me know if this would be possible and if there are any queries needed on my end.