Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |