Forum Discussion
Slicer - advanced filtering
Let's say I have a book store where I sell books from different publishers. I would have a slicer with publishers and when I select a publisher I show a chart with books totals been sold from the selected publisher. My problem is that the chart would have to show too many books and there will be not enough space for this chart. Instead I am thinking to show top 10 books that were sold the most. I am looking into the advanced filtering, but can't find a way to specify the result of filtering has to be <= 10. Any idea? Should take a different direction?
Thanks
Hi Markzolotoy,
The filter should be placed on the visual you present the top10 books in (in the filter pane), not in the slicer. Take a look at this image and lemme know if that clarifies! 🙂
6 Replies
Hi!
In the filter pane in the same dropdown box where the advanced and normal filter can be selected the should also be a "TopN" option. This option will allow you to filter the results based on the top or bottom N sales.
Regards,
Tim
timg Do I need to add an item that would be top 10 of?
You could also use the approach in this video to show the top 10 books and the total for all other books. It is more advanced that using the Top N option in a visual slicer, but FYI that this capability is there.
Filtering the top products alongside the other products in Power BI - SQLBI
Pat
timg Not sure how to do it.
Here is my table:
Publisher Book count
The slicer is based on Publisher. When I select a publisher I need to show top 10 books been sold. I am adding another field "Book" to the Publisher filter and I am saying TopN with a value of count. Not working for me.
Hi Markzolotoy,
The filter should be placed on the visual you present the top10 books in (in the filter pane), not in the slicer. Take a look at this image and lemme know if that clarifies! 🙂
Hi, Markzolotoy
Has timg’s reply and sample picture helped you to find the solution to this problem? Because the TopN filter to the [Count] column can perfectly help you to get the Top10 books of each publisher.
If so, would you like to mark his reply as a solution so that others can learn from it too?
If you still have a problem, you can post some sample data on your side (without sensitive data) and your expected result.
Thanks in advance!
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
