Data Filtering

[MalvikaBhasin]

Hi,

Why is my filtering option not working? 

I want to limit my data in bar graph to just 5 cities. How can I do that?

Regards

Malvika

[Anonymous · Accepted solution]

Use a Filter in the Filter pane to the Top 5 by amount

[Ritaf1983 · Accepted solution]

Hi @MalvikaBhasin 
The wanted filtering logic is unclear. If, for example, it's a top/bottom 5, you can do it like this:

The pbix is attached

If you meant something else 

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Use a Filter in the Filter pane to the Top 5 by amount