Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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?
Thanks but I can't split my fact table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |