Forum Discussion

Elisa_E's avatar
Elisa_E
Helper I
8 years ago
Solved

Dynamic text based on slicer

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.

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    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. :smileyhappy:

     

    Regards

4 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi Elisa_E,

     

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

    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's avatar
      Elisa_E
      Helper I
      8 years ago

      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's avatar
        v-ljerr-msft
        Microsoft Employee
        8 years ago

        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. :smileyhappy:

         

        Regards