Forum Discussion
Visualization (Buttons and Slicers)
You could just create another conditional formatting measure but this time should be applied to the callout value of the buttons.
Slicer Highlight Color = IF ( SELECTEDVALUE ( MonthsOnly[Month Short] ) IN VALUES ( Dates[Month Short] ), "white" --#ffffff for hexadecimal )
If you disable the interaction then you can't really expect them to sync. There is currently no option to cross-highlight instead of cross-filtering the interaction between slicers. The default behaviour of a slicer to is to cross-filter even non-slicer visuals. That said, your workaround is to use dimensions that are not directly related to each other - quarter coming from the regular table and months from a months only table but still related to fact. Your diagram would look like below.
Cross-highligting will be done via conditional formatting. Create a measure that will check whether the months in MonthsOnly are currently visible in Dates table
Slicer Highlight Color =
IF (
SELECTEDVALUE ( MonthsOnly[Month Short] ) IN VALUES ( Dates[Month Short] ),
"#ADD8E6"
)
Crossfiltering/highlighting from months to quarter also uses a measure in a visual filter or conditional formatting.
Please see the attached sample pbix.
Hi danextian, thanks for your help, again.
Is there any way that I could make the font color in the button slicer becomes white after it has been highlighted. For example, when Q1 is selected, Jan, Feb and March will be highlighted and the font will be white (#FFFFFF).
I would appreciate it if you could help me with these inquiries.
Thank you.
You could just create another conditional formatting measure but this time should be applied to the callout value of the buttons.
Slicer Highlight Color = IF ( SELECTEDVALUE ( MonthsOnly[Month Short] ) IN VALUES ( Dates[Month Short] ), "white" --#ffffff for hexadecimal )It still doesn't seem to work. Whenever I tried to select 2 quarters at the same time, the font becomes black again (in month). Really appreciate it if you could help me with these.