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
ovetteabejuela
Impactful Individual
Impactful Individual

Visual Filters | How to clear them

Sorry, subject seems easy to answer but theres a twist.

 

Say, in a page I have a simple table and 2 slicers.

1. I selected items from the slicers

2. From the raw data I removed all the files thats in there(CSVs).

3. I loaded new set of data (CSVs)

***remember I still have the items selected on the filters...

4. Hit Refresh

***Table is empty!!!

 

I guess the reson is I had preselected items on the slicers that is not available on the new data set, resulting to an empty table.

 

But I can't clear the filters now because it has a new set of values already,

 

Now there is a work around... I can delete the filters and bring it back - the table will now have data in it.

 

But what I want to know is --- is there another way beside the work-around I mentioned to clear the filters? I also check on the visualizations pane but nothing in there suggest that I can clear something.

1 ACCEPTED SOLUTION
ovetteabejuela
Impactful Individual
Impactful Individual

Fool - just select an item(based on the new dataset) in the slicer and it will go away and also that little light-colored eraser icon which says clear on the tool tip should clear the selection from that particular slicer.

View solution in original post

1 REPLY 1
ovetteabejuela
Impactful Individual
Impactful Individual

Fool - just select an item(based on the new dataset) in the slicer and it will go away and also that little light-colored eraser icon which says clear on the tool tip should clear the selection from that particular slicer.

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.