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
Icon for Super User rankSuper User
1 year ago

Hi aziffarhan Are the columns coming from the same table? If so, selecting a value in any of the slicers should crossfilter the others unless visual interactions between them have been disabled. If the columns are from different tables, it can cause issues with filtering behavior. As a best practice, use a dedicated date or calendar table that includes all relevant date components (such as date, year, month, quarter, day, week number, etc.).