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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

0

Slicer - when no items are selected then it is not modifying filter context to adhere to the 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

2. Create a table visual with both these columns

3. Create a slicer visual with column 1

4. Click on the slicer visual, and under the filter pane choose advanced filter `is less than` 6.

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

6. If you select any slicer value, the table visual will get filtered to show that record. However, if you dont select any value (or if you have enabled `select all` functionality and you do `select all`), then the table visual shows all values - that is 6, 7, 8, 9. 10. So the slicer filter isn't adhered to by the other visuals when no slicer items are selected (or when `select all` functionality is used)?

Status: Delivered
Comments
Anonymous
Not applicable

Hi @nachthl 

Your current filter is for slicer as a visual, not for the whole page, and the table values are definitely not filtered. What you need to do is to filter the corresponding data at the page level.

vyetao1msft_0-1712301204949.png

When you put column into the page hierarchy, you'll find that table gets filtered as well.

vyetao1msft_1-1712301371367.png

 

Best Regards,
Community Support Team _ Ailsa Tao

 

 

 

 

nachthl
Frequent Visitor

I agree that I have filtered the slicer. But then, when I select all on the slicer, and effectively it should then filter the other table for those records only right? have a look at the detailed example I have posted here: https://community.fabric.microsoft.com/t5/Desktop/Slicer-when-no-items-are-selected-then-it-is-not-m...

 

@Anonymous 

This widget could not be displayed.