cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Post Partisan
Post Partisan

Slicers selection is retained in Power BI Desktop

Hi All,

 

For the attached pbix file.

I see the slicer selection is retained.

Is there any way to remove that. ?

 

I selected Vendor V1, Selected Product A1 selected catgory A and then Product as A2.

Now when I change the selection to V2, the earlier selection of Product A1 is reatined which I don't want.

 

https://onedrive.live.com/?cid=05762E425585F411&id=5762E425585F411%21105&parId=root&o=OneUp

 

Regards,

Akash

10 REPLIES 10
Memorable Member
Memorable Member

Hi @akj2784,

 

Not able to access the file. Make sure the link is public.

 

Prateek Raina

are you able to access now ? Not sure how to make it public.

Hi @akj2784,

 

You can do this by using Chiclet slicers.

Refer to the this PBIX file and let me know if this works for you.

 

Prateek Raina

Not able to save the pbix file .

Chicklet has record limitation. In my real time dataset Slicers have a lot of values and it gives error "Too many values..... " when I use Chicklet

Try Hierachy slicers. They might handle both the scenarios (Data + Selection)

 

Prateek Raina

Unfortunetly that also has limitations. 

Hi @akj2784

 

I don't think then there is any solution to it. 

Only workaround which I think is, You can create a Clear Filter button near your slicers.

 

On hitting this button, it will clear all the selections in the slicers and then you are good to go again. It will not retain the selections.

 

Prateek Raina

ok.. Thanks Prateek for the reply.

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors