power bi filters

[Anonymous]

Hi All,

is there any way in power bi where we want to reset all filters on page except one-two.

My main problem is  user is selecting country and currency from start and that is carry forward to all pages and i dont  want those filters to clear even if he moves to another page and clear all selections while doing analysis.

[Anonymous]

any help?

[SamInogic · Accepted solution]

Hi @Anonymous ,

As per our understanding, you are looking for a way to remove the Filters some Selected Filters applied on your table,

This you can achieve by Bookmark and Button for triggering the action 

Initially, you have to select the Slicers from which you want to remove the filter, 

And add a bookmark (For selected visuals)

Have a name and make changes in Bookmark for selected visuals 

Now Create a blank button,

Turn on the action and do as same in the Screenshot

Under the Style Give Button name 

Finally, you can change slicer values 

When you will click on the remove filter button it will remove the Filters applied to the Selected visual on Bookmark 

If this answer helps, please mark it as an Accepted Solution so it would help others to find the solution.

Thanks!

Inogic Professional Service Division

An expert technical extension for your techno-functional business needs

Power Platform/Dynamics 365 CRM

Drop an email at crm@inogic.com

Service:  http://www.inogic.com/services/ 

Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

[Ahmedx]

1)  REMOVEFILTERS() removes all filters
2) VALUES restores a specific filter

Measure = CALCULATE( [sales],REMOVEFILTERS(), VALUES('Table 1'[Column1]),VALUES('Table 1'[Column2]),VALUES('Table 1'[Column3]))

[Anonymous]

How should we should these functions ? in button or bookmark ?

[Arul]

@Anonymous ,

You can use sync slicers option under the view tab to sync slicers from different page.
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-desktop
https://k21academy.com/microsoft-azure/data-analyst/power-bi-slicers/
For clearing all slicer you can use latest clear all slicer option under insert (this is available in March 2023 update) please update the latest one if you want this feature. 
March update - https://powerbi.microsoft.com/en-us/blog/power-bi-march-2023-feature-summary/

Thanks,

Arul

[Anonymous]

This sounds good but my problem is still not solved beacuse i dont want country and currency filter to clear out  . 

[Avantika-Thakur]

Hi @Anonymous ,

You won't be able to selectively clear the slicers and let the selections in Country and Currency slicer remain as is.

Instead you can try using the "Clear Selection" option available at individual slicer level as shown below

Hope this helps!

Thanks,

Avantika