Forum Discussion
Top N stacked bar graph does not filter the values based on additional filter
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
4 Replies
v-qiuyu-msftCommunity Support
Hi Anonymous,
Would you please share some sample data then clarify corresponding result?
Best Regards,
Qiuyun Yu- v-qiuyu-msft
Hi Anonymous,
You can create a measure below:
Measure = CALCULATE(SUM('Table'[Amount]),FILTER('Table','Table'[Country]=MAX('Table'[Country])&&'Table'[State/Province]=MAX('Table'[State/Province])))Then set a TopN filter for chart based on this measure:Best Regards,
Qiuyun Yu
- amitchandak
Super User
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
