Forum Discussion
Visualisation (Slicer and Button Slicer)
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):
- 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.
- 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.
- 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?
- 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?
- 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
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
7 Replies
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
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. 😊Probably because i have preview options on
no worries, single selection might fix your issue
if it helps, please mark as solution