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

Displaying only Top N% of Values

Hello All,

My data is in the below format -


data format.PNG

 

 

 

 

 

 

I want show values and L2 region when I select a L3 region. But I want to display only those values that are in the top 10% of values (of the selected region). My dataset is quite large with 800K entries and there are a lot of entries whose values are quite small. So I want a user's focus only the big ticket values (i.e. top 10% of values).

Please help!

1 REPLY 1
pbininja1 Frequent Visitor
Frequent Visitor

Re: Displaying only Top N% of Values

I tried the solution in https://community.powerbi.com/t5/Desktop/Top-N-percent-filter/td-p/682552 but it doesn't work for me.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors