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 car...
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

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

      • Elisa_E's avatar
        Elisa_E
        Helper I
        8 years ago

        This works perfectly! Thank you so much!