Forum Discussion
Visualisation (Slicer and Button Slicer)
- 1 year ago
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
Thanks for confirming. Please do share your thoughts on the given approach and let us know if faces any issues.
If the issue has been resolved, can you mark the post as resolved and dont forget give kudos.
Best Regards,
Cheri Srikanth