Filter Selection

[jayjani]

Hello,

I have a Slicer filter as shown in the image below. When I toggle from Jul to Jun, I want the budget to remain selected (Budget should remain selected all the time no matter what the month may be).

Is there a way I could do it even through a feature or modelling my data? I don't want to press Ctrl and do select/unselect. Also, in future I will have all 12 months, so I wish to change it to a dropdown.

[v-diye-msft]

Hi @jayjani ,

Based on my research . it's not supported to remain the one of the selection in slicer. if you'd like to get some workaround, it's preferred to share us your dummy pbix, and further M expression/DAX might help.

Best regards,
Dina Ye

[jthomson]

Maybe you could try splitting your data into two tables - one for the budget, and one for everything else, and then just have the slicer point to the second table?

[jayjani]

Thanks but I can't split my fact table.