Forum Discussion
Visualisation (Slicer and Button Slicer)
Hi Anonymous
Thank you for being part of the Microsoft Fabric Community.When you select Q1 in the Quarter slicer, the Month slicer gets filtered automatically to show only January, February, and March, since those months fall under Q1. Even though the Month slicer reflects this filtered state, the values inside it don’t turn black because no direct user selection was made on that slicer. Power BI only highlights items in black when a user manually clicks on a value. This is the expected behavior and not something that can be turned off through settings.
To work around this, one approach is to create two slicers tied to the same date field — one for Quarter and one for Month. Keep the Quarter slicer visible and hide the Month slicer. This way, users make selections using only the Quarter slicer, and the Month slicer still filters visuals in the background without showing any black highlights.
Another method is to build a separate, disconnected Quarter table for the slicer and write DAX logic that filters visuals based on the selected quarter. Since this custom slicer doesn’t interact with the Month slicer directly, you avoid any cross-filtered visuals altogether.
Alternatively, using a hierarchy that includes Year, Quarter, and Month in a single slicer gives users a cleaner experience. Expanding and selecting values within a single hierarchy removes the confusion of separate slicers showing different selection behaviors.
If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.
Hi Anonymous
Thank you for being part of the Microsoft Fabric Community.When you select a Quarter, Month, or Year slicer in Power BI, the other slicers update automatically because they are all connected through the same underlying Date table or related columns. Even if Quarter and Month are custom columns (not part of the original hierarchy), as long as they come from the same date table linked to your data, selecting one filters the others accordingly.
So, selecting Q1 filters the Month slicer to show only Jan, Feb, and Mar as active (black). Selecting a month like August filters the Quarter slicer to highlight the quarter containing August. Selecting a Year filters both Quarter and Month slicers to show only the relevant periods in that year.
This cross-filtering and color change happen automatically due to the relationships and filter propagation in your data model, regardless of whether you use the standard Slicer or Button Slicer visual. Just ensure your Year, Quarter, and Month columns come from the same date table with proper relationships to your fact data.
If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.
Hi v-csrikanth , thank you for replying, much appreciated.
I understand how slicer works, however if I select "Quarter (Q1)" slicer only and it turns black and the "Month" slicer is automatically showing "Jan", "Feb", and "Mar" but NOT turning black like the quarter I selected because I dont want to select "Month" slicer, and my question is how do I turn of black color on "Month" slicer even thought I dont select any month from "Month" slicer and only select "Quarter" slicer?
Thank you in advance. Have a nice day. 😊