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

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.

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.