Forum Discussion

Resolver III

9 years ago

Step by Step Slicer Selection Title

Hi, Am find difficult to write DAX function Below is the Example. I Have 3 Slicer First Title “Select Country” after country selected Second Title “Select Pharmaceutical” after Pharmaceutic...

Anonymous

Not applicable

8 years ago

HI chethan,

>>Default Chart Title must be “Select A Slicer” If I have not selected the Slicer A,If Slicer-A Selected Chart Title must be “Select B Slicer” If I have not selected the Slicer B If Slicer-B Selected Chart Title must be “Select C Slicer” If I have not selected the Slicer C

Current power bi not support dynamic chart title, I'd like to suggest you submit it to ideas forum or hide chart title and use card visual as the dynamic title.

Sample: ISFILTERED with IF statement to achieve dynamic measure.

Check =
IF (
    ISFILTERED ( TableA[Amount] ) && ISFILTERED ( TableB[Amount] ),
    "All Selected",
    IF (
        NOT ( ISFILTERED ( TableA[Amount] ) ),
        "Select SlicerA",
        IF ( ISFILTERED ( TableA[Amount] ), "Select SlicerB" )
    )
)