Forum Discussion

7 Replies

    • SivaMani's avatar
      SivaMani
      Resident Rockstar
      8 years ago

      Hi chethan,

       

      I'm Sorry. I didn't get you.

       

      What are you looking for?

       

      What is your requirement?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI chethan,


    Do you want to show the custom title on slicer?
    If this is a case , you can turn on the option at format tab and input the custom title.

     

    If above not your goal, please share more detailed information about your requirement.

     

    Regards,

    Xiaoxin Sheng

    • chethan's avatar
      chethan
      Resolver 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