Power BI desktop, Clear all slicers Table Vizalisations don't work

[Turhan_Batur]

Dera community,

I am Working with Power BI Desktop Version ( 2.122.746.0 64-bit ) and I am using the Buttong "Clear all Slicers" to clear all my slicers on this dasboard, usually it work fine for most of my Vizualisations.

Unfortunately , I have got also "Table Visualization" and when I am selecting one row, the Filter apperas to all my slicers. (correct behaviour).

But when I am using the "Clear all slicers" button, there is no effect in Table Vizualization.

Can someone telle me how to solve this ?

Thanks in advance

Turhan

[v-tianyich-msft]

Hi @Turhan_Batur ,

It looks as if you are filtering the data through filter and then trying to clear all filters using clear all slicer, which is incorrect. It's true that you filter selects a row of data and slicer it changes, but it's not applied so you can't clear it. Besides, if you click apply and then clear it, it will still be the same because the filter is still there.So you need to clear filter.

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Turhan_Batur]

Hello Scott, 

thanks for your feedback,

1.)When I am clickingin on row of an table, the filter appers to all other slicers.

Then when I am using "clear all slicers" button, the filter is not removing.

This happens only at table visualizations.

2.) Even when I am clicking in the table row, all other slicers are filtered , but the in the "Filters" Section the entry is not marked.

Here an example, no row is clicked:

When the row DD is clicked in table fzart (middle table), the entries of all other sclicer changed, no checkmark in the Filters section:

[Bmejia]

Looking at your print screen I see the visual with the bar is darken color meaning is selected so visual does not get affected.  Try going back to editing the interactive view and make it so is not greay out see if that works.

[Turhan_Batur]

Hallo Bmeja,

even wehn this is not "grea", the same...

Unfortunately I think to repoduce that, you have to create a small dataset with Table Visualization and Slicer Visualization with Checkbox, and then look how the "Clear all slicers " has an affectto both...

[Bmejia]

Sorry not sure what else it could be the reason.   I recreated your scenario with one of my report and the only  reason that I can think of is if the visual does not change is cause of this.  I am not sure what else could be without actually looking at the file.

make sure that is the visual that you are doing the changes. if the circle is selected then it won't change.

[Turhan_Batur]

you are really helping me a lot...I really apreciate...;)

The issue is only at TABLE Views , all other visualizations are working by "Clear all Filter".
There is no effect only for this Type 

here my table 

Bar chart or other everything works fine...

[Bmejia · Accepted solution]

If are using just the filter, it should clear out all your table and go back to viewing everything in both tables. 

If you are selecting a individual line from a table like below and you click on Clear All Slicers nothing will happend because the Clear all Slicers is only clearing what you have filter not what you have selected in the table.  If this is the case you might want to create a bookmark that will basically take you back to the default view.

[Bmejia]

The Clear All Slider does not filter out any filters in the filter pane on your right.   Only the filter that you have on your page.

[Turhan_Batur]

Hello Bmejia,

you are right...and  this is "OK"...

But the "Clear All Slider" still doesn't work for table Vizualizations on my page.
(For all other slicer types it works)

regards

Turhan

[Bmejia]

That is probably cause the slicers interaction was  set not to change when you apply a particular slicer. 
To remove the slicer interaction,  select the matrix or visual in your report then go to format. Click on Edit Interaction.

if the cut circle/bar filter is greyout means it is set to not change even if you apply a filter or clear all filters. 

So you want to click on it and clear the circle/bar filter if you want the filter or matrix to interacts with othes visuals including clear all slicers.

[Turhan_Batur]

Hello Bmeja, 

thanks for your answer, the  format is correct (not greyed out) , buit still not wokring: