Dynamic text based on slicer

[Elisa_E]

Hello,

I have a some string text I would like to include on top of a chart showing sales when certain a first slicer is selected. This first variable is "company". I managed to do this with a card and calculated column, however, I need the text to disappear when other filters are selected (e.g. "service type" and "region".). All slicers are columns and I'm not sure how to activate one and deactivate the others.

Thank you.

[v-ljerr-msft]

Hi @Elisa_E,

Based on my test, the formula below should work in your scenario. 

Measure =
IF (
    HASONEVALUE ( 'region'[region] ),
    FIRSTNONBLANK ( region[region], 1 ),
    IF (
        HASONEVALUE ( 'service type'[service type] ),
        FIRSTNONBLANK ( 'service type'[service type], 1 ),
        IF (
            HASONEVALUE ( 'company'[company] ),
            FIRSTNONBLANK ( 'company'['company'], 1 )
        )
    )
)

Remark: You'll need to replace the bold with your real table name and column name.

Regards

[Elisa_E]

Hi @v-ljerr-msft,

Thanks for this! I tried this measure as a visual filter, (show items if = 1), but then the visual then won't show at all, so I'm likely doing something wrong.

What I am trying to do is show text (from the dynamic text column below) only when Company A or B is selected in a slicer. I've managed this with a card. However, I need this text to disappear when a specific region or service type is selected. Not sure if this is possible.

Thanks again.

[v-ljerr-msft · Accepted solution]

Hi @Elisa_E,

Could you try using the formula below to create a measure, then just show the measure on the Card visual(no need to apply it as visual level filter) to see if it work in your scenario?

Measure = 
IF (
    HASONEVALUE ( Table1[Region] ) || HASONEVALUE ( Table1[Service Type] ),
    "",
    IF (
        HASONEVALUE ( Table1[Company] ),
        FIRSTNONBLANK ( Table1[Dynamic text], 1 ),
        ""
    )
)

Remark: You'll need to replace Table1 with your real table name.

Here is the sample pbix file for your reference. 

Regards

[Elisa_E]

This works perfectly! Thank you so much!