Forum Discussion

aziffarhan's avatar
aziffarhan
Regular Visitor
1 year ago
Solved

Visualization (Buttons and Slicers)

Hi everyone! I'm currently working on an interactive Power BI dashboard and I’ve run into a challenge. I want to include slicers and buttons that allow users to filter by Year, Quarter, and Month. ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    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
)
danextian's avatar
danextian
Super User
1 year ago

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
)
aziffarhan's avatar
aziffarhan
Regular Visitor
1 year ago

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.