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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nachthl
Frequent Visitor

When `select all` is used, then slicer doesn't respect the visual level filter

Steps to replicate the issue/bug:

1. In Power BI Desktop, click on Enter Data and create a table having 2 columns. In column 1, enter values 1-10; and in column 2, enter values a-j. Load this table into Power BI.

 

nachthl_0-1712219191738.png

 

2. Now create a table visual with both these columns

nachthl_1-1712219285224.png

 

3. Create a slicer visual with column 1, SLICER TYPE should be dropdown, and under SELECTION choose `Show "Select All" ...`

 

nachthl_2-1712219374573.png

nachthl_3-1712219417064.png

 

4. Click on the slicer visual, and under the filter pane -> `Filters on this visual` -> filter on this column such that it shows items with value less than 4, and click on `Apply Filter`

nachthl_4-1712219498904.png

5. Now your slicer will show values from 1 to 3

 

nachthl_5-1712219512472.png

6. If you select any slicer value, the table visual will get filtered to show that record.

nachthl_8-1712219621534.png

 

7. However, if I choose `Select All`, with the intention that the table should show data for all items in the slicer, then the table visual shows all values. Shouldn't it only show 1 to 3?

 

nachthl_7-1712219604062.png

 

 

6 REPLIES 6
PijushRoy
Super User
Super User

hI @nachthl 

If you are using a Visual level filter (in your example), it will only work on specific visuals.
If you want multiple visual filters, please use Page or report-level filters.
Ref link
https://www.phdata.io/blog/slicers-vs-filters-power-bi/#:~:text=Visual%20level%20filters%3A%20filter...

 

https://powerbiconsulting.com/types-of-power-bi-filters/

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

I agree that visual level filter on slicer will only impact the slicer. But, once the slicer is filtered and it shows 1, 2, 3, then, when I choose SELECT ALL on the slicer, which effectively means select 1, 2, 3, then, this slicer should filter the other table visual as well. Shouldn't it? 

 

Do you want me to tell the users that selecting SELECT ALL in the slicer will select 1 to 10, even thought the slicer has 1 to 3?

mussaenda
Super User
Super User

Hi @nachthl,

 

On your Step 4, you applied the filter only in the Visual. It means it will only affect that visual. Not all the visuals pf the page.

 

If you want it to affect all visuals, you should not apply it on visual level.

It should be page level.

On step 4 I indeed applied filter to only the slicer visual. Therefore, when I click on the SELECT ALL in slicer, effectively it means that only values 1, 2, 3 are selected, therefore this must automatically filter the table, because the slicer has only 1, 2, 3 in the list..  So this looks like a bug in the slicer's SELECT ALL implementation?

PijushRoy
Super User
Super User

hI @nachthl 

If you are using a Visual level filter (in your example), it will only work on specific visuals.
If you want multiple visual filters, please use Page or report-level filters.
Ref link
https://www.phdata.io/blog/slicers-vs-filters-power-bi/#:~:text=Visual%20level%20filters%3A%20filter...

 

https://powerbiconsulting.com/types-of-power-bi-filters/

 


Let me know if that works for you


If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

If you see my steps to replicate, I have now provided visual screenshots to explain the issue. The slicer visual filter is filtering the slicer. This will not filter the table, I agree with you. But when I choose SELECT ALL in the slicer (or if I don't select any slicer item), then shouldn't it show only those values in the table visual?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.