Step by Step Slicer Selection Title

[chethan]

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 Pharmaceutical

Third Title “Select Medicines”

 

[Anonymous]

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]

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]

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]

Its not working

[Anonymous]

HI @chethan,

Can you provide more detail informations?

Regards,

Xiaoxin sheng

[chethan]

[SivaMani]

Hi @chethan,

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

What are you looking for?

What is your requirement?