Skip to main content

    Power BI

    New

    [Slicer] add isfiltered in background color setting

    Vote (2) Share
    Nancy Weigel's profile image

    Nancy Weigel on 29 Mar 2024 09:32:13

    Hi,


    • I have a slicer with field DIM1,
    • I create a measure: IS_FILTERED_DIM1=if(ISFILTERED(DIM1), "#FFF000", "#E6F5FF")


    The goal is to add measure IS_FILTERED_DIM1 in the Background color settings:

    • if I select a value in field DIM1, le background is #FFF000
    • else "#E6F5FF"