cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jayjani Frequent Visitor
Frequent Visitor

Filter Selection

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.

 

 

image.png

3 REPLIES 3
jthomson New Contributor
New Contributor

Re: Filter Selection

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 Frequent Visitor
Frequent Visitor

Re: Filter Selection

Thanks but I can't split my fact table.

Community Support Team
Community Support Team

Re: Filter Selection

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

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,623)