Forum Discussion
Top N Percent Matrix Visual
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.
3 Replies
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
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.
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
