Visualisation (Slicer and Button Slicer)

[jollybeaanz]

Hi everyone, I hope you all have a nice day.

I want to ask if (Picture in order), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the first picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date").

My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation):

1. In Picture 2, if I select Q2, how do I maintain the month shape? I dont want it to be showing only ("Apr", "May", and "Jun" only even thought I know Q2 meaning those three months), I want to maintain them in 12 months if I select Q2 only or any quarter.
2. In Picture 3, if I select month "Aug", how do I maintain the quarter shape? I dont want it to be showing only "Q3" even thought I know August belong to Q3, I want to maintain Quarter in four quarter ("Q1, "Q2", "Q3", and "Q4") even if I select any month not belong to that particular quarter.
3. In Picture 5, if I select Q1, how do the visualisation slicer for months is also turn black even thought I only select Quarter slicer?
4. In picture 5, if I have visualisation (for example bar graphs for Q1 sales reporting), if I save the Power BI + publish the report and close the app and when I open back the final published report, how to maintain the slicer selected for "Year 2025", "Q1", and "Months (Jan, Feb, and Mar)" without me selecting the slicers to show Q1 so it already showing Q1 sales reporting when I re-opened the published report?
5. In Picture 6, if I select Year "2025", how do the visualisation slicer for quarter and months also turn black without me selecting Quarter and Month slicer? 

Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏

Picture 1Picture 2Picture 3Picture 4Picture 5Picture 6

[Vijay_Chethan · Accepted solution]

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 settings

you can find editting interaction in format tab, for interaction for eachother and turn on force selection

if this helps, please mark as solution

[jollybeaanz]

To be clear that my "Button Slicer" visualisation doesnt have "Force Selection" like yours.

[Vijay_Chethan]

Probably because i have preview options on

no worries, single selection might fix your issue


if it helps, please mark as solution

[jollybeaanz]

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. 🙂

[v-kathullac]

Hi @jollybeaanz ,
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.

[jollybeaanz]

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.

😊🙏

[jollybeaanz]

Hi @Vijay_Chethan , thank you so much for answering my questions.

I tried to follow your tutorials, however I noticed that I dont have the option that you screenshotted. Do you know what happen?

Thank you in advance and have a nice day. 😊