Slicers selection is retained in Power BI Desktop

[akj2784]

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

[prateekraina]

Hi @akj2784,

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

Prateek Raina

[akj2784]

https://1drv.ms/u/s!AhH0hVVCLnYFaUfcoeKuFMP9QKo

[akj2784]

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

[prateekraina]

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

[akj2784]

Not able to save the pbix file .

[akj2784]

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

[prateekraina]

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

Prateek Raina

[akj2784]

Unfortunetly that also has limitations. 

[prateekraina]

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

[akj2784]

ok.. Thanks Prateek for the reply.