cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 4
Highlighted
Community Support
Community Support

Hi @SuG

 

Would you please share some sample data then clarify corresponding result? 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

TopN_DataSample.png

Highlighted

Hi @SuG

 

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: 
 
q3.PNG
 
Best Regards,
Qiuyun Yu
Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Super User IV
Super User IV

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors