Forum Discussion
Visualisation (Slicer and Button Slicer)
Hello jollybeaanz,
well a simple solution would be turning off the interaction between slicers, then you can achieve your question 1 2,3 and 5
about question 4 please select option selet on in slicer settingsyou can find editting interaction in format tab, for interaction for eachother and turn on force selection
if this helps, please mark as solution
Probably because i have preview options on
no worries, single selection might fix your issue
if it helps, please mark as solution
I see that the force selection works when "Single Selection" is turned on. Unfortunately, I don’t want to enable "Single Selection" because I need to display multiple months in my report (such as Q1/Q2 or a 6-month reporting period, for example).
I truly appreciate your answers. However, please let me know if you find any other way to address my question or maybe you have any tips for this.
Thank you so much. 🙂
Hi Anonymous ,
Thank you for reaching out to Microsoft Fabric Community Forum.-
Power BI does not currently support forcing a selection in multi-select slicers without enabling "Single Selection."
-
Since you need multiple months selected, enabling "Single Selection" is not an option.
-
A common approach is to use DAX measures that detect if no months are selected and then default to a predefined month set (like Q1 or a 6-month period) for your calculations.
-
You can also add a card visual with a message prompting users to select at least one month if nothing is selected.
-
Another option is to use bookmarks with default multi-month selections applied on report load to avoid empty slicer selections initially.
-
Although these methods don’t physically force a selection in the slicer UI, they ensure your visuals show meaningful data and guide users to make selections.
Regards,
Chaithanya.
Hi v-kathullac ,
Thank you so much for replying to my question — I truly appreciate it. I will try your ideas and let you know whether it works for me or not.
Thank you once again.😊🙏
-
