Forum Discussion

chethan's avatar
chethan
Icon for Resolver III rankResolver III
8 years ago

I Need a DAX help to create the Dynamic Chart Title  

For Example

I Have 3 Slicer

A Slicer

B Slicer

C Slicer

I have plotted the chart based on my C Slicer & Month

Below is my DAX measure calculated on Value

 

IF( AND(HASONEVALUE('Table'[A]),HASONEVALUE('Table'[B])),IF(HASONEVALUE('Table'[C]),AVERAGE('Table' [Service Level]), BLANK() )

 

I Need the Chart Title to be create

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

 

Anonymous's avatar
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" )
    )
)

 

 

Regards,

Xiaoxin Sheng

  • chethan's avatar
    chethan
    Icon for Resolver III rankResolver III
    8 years ago

    Its not working

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      HI chethan,

       

      Can you provide more detail informations?

       

      Regards,

      Xiaoxin sheng