Forum Discussion
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.
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
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
2 Replies
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
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