Top N Filter is not working with multiple dimensions on X-Axis of a Bar Chart.

[vikc]

I have a stacked column chart with multiple dimensions on x-axis as below.

I want to apply TopN filter on each dimension (Display Top 10 Count of Requests by each hierarchy). But Power BI allows only one TopN filter per visualisation (see below).

 

Please suggest a workaround.

P.S. I've also tried with using 5 measures for each dimension too but somehow I am missing something beacuse its not working as expected.

[CahabaData]

I recommend you check out the YouTube video by Sam McKay of Enterprise DNA New Zealand with the name: Create Dynamic Visuals based on Ranking.

He goes thru setting up visuals using RankX - and based on your post I think that is the approach that you are going to need to do.

[vikc]

Thank you @CahabaData for the response, the video explains dynamic ranking but my problem is to filter multiple dimensions by Top N filter.