Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
cuongle
Advocate II
Advocate II

TOP N Filter cannot be used twice

TOP N Filter cannot be used twice in Power BI:

 

TopN.PNG

 

Is there any workaround that we can do in this case?

1 ACCEPTED SOLUTION

Perhaps using RANKX to rank either suppliers or months and then just using a < filter?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
AxelPrunier
Advocate II
Advocate II

Hi,

 

I also think this would be a really cool feature to be able to apply multiple Top N filters a Visual level. 

 

In fact, it is much more convenient than creating an additional RANKX measure (especially when you work on a file that is already full of "tool" measures...).

 

Is there any chance this could be implemented?

 

Many thanks,

Axel

Greg_Deckler
Super User
Super User

Can you explain the use case for having two TOP N filters?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

I would like show top 10 suppliers based on spend on 6 latest months. So, in that case I want to have TOP 10 Suppliers and TOP 6 months

Perhaps using RANKX to rank either suppliers or months and then just using a < filter?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.