Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
here is an example.
I have 3 countries.
Each country has some regions.
Each region has temperatures for each month.
I want to show the stacked graph to show the TOP5 regions with highest temperatures for last 6 months
As we know topN pulls whole data, sorts to find top N and simply shows the values for those categories ( regions) over 6 month period.
Now,I want to apply the filter of countries. I want the TopN to look for the data from only selected countries, apply the Top5 logic only for temperatures for regions from selected countries and replot.
I noticed this does not work as expected above.
Does anyone know how to solve this?
-SuG
This one should help
https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/
You have to filter a using rank
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
Hi @SuG,
You can create a measure below:
Hi @SuG,
Would you please share some sample data then clarify corresponding result?
Best Regards,
Qiuyun Yu
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |