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
Anonymous
Not applicable

filtering top 10 + filtering out empty value

Hi all,

 

I'm trying to see total backlog per supplier.
I want to see only the top 10 suppliers with highest backlog.  I know I can do this with the TOPN filter on the visual.
However, a lot of lines in my table have no supplier listed, meaning the cell is empty.
How can I make sure these lines are not included in the visual?

 

Thanks for the help.

2 ACCEPTED SOLUTIONS
Asac_14
Resolver I
Resolver I

Put a seperate filter for removing the blanks from suplier and again use the same column for top N filter with value column as back log. Pls accept this as solution if it resolves your problem. 

 

Thanks & Regards,

KK

View solution in original post

amitchandak
Super User
Super User

put a visual level filter to take out blank. Same place you have a top 10 option.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

put a visual level filter to take out blank. Same place you have a top 10 option.

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

Asac_14
Resolver I
Resolver I

Put a seperate filter for removing the blanks from suplier and again use the same column for top N filter with value column as back log. Pls accept this as solution if it resolves your problem. 

 

Thanks & Regards,

KK

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.