How to display sentence in tooltips?

[Anonymous]

Hello experts,

How can we show sentence in tooltips? 

For example, if it is a Public Holiday i want to provide some details for it.

eg : Public Holiday (It's a Holiday for a country............)

       State Holiday (It's a ..........)

       Non Holiday (It's a ..........)

OR 

Can we display the sentence in the legend? (Public Holiday, State Holiday, Non-Holiday)

Really need your help. Thank you in advanced.

Regards,

Izzaty

[PaulDBrown]

Depending on how your data is set up, you could create measures for each category to use in the tooltip bucket- Something along the lines of:

To show the public holiday dates:

Holiday Dates =
VAR _HD =
    CONCATENATEX (
        FILTER ( VALUES ( Table[Date] ), Table[Date type] = "Public Holiday" ),
        Table[Date],
        ", "
    )
RETURN
    "Holiday dates: " & _HD

[Saap]

Hi @Anonymous 

You can create measure where you specify the text you want to show.
Then put this measure in a tooltips field in a visual.

[Anonymous]

Hi @Saap 

I tried & it works.. but, it doesnt really serve purpose as i want to display the meaning for each holiday..

If i add the measure, even if it's not holiday, then it will show details on holiday..

Is there any way we can add the sentence in the legend? so that when user hover to the legend for example Public Holiday, then it will display the meaning of it..

[Anonymous]

Hi @Anonymous ,

You can refer the following links to achieve it.

Dynamic tooltip with text measure

To update your measure as below.

dynamic_tooltip = 
var _lan_ = SELECTEDVALUE('Table'[Lan])
return
SWITCH(_lan_, "FR", "Texte en français","EN","Text in English")

---

A TRULY DYNAMIC TOOLTIP

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. By the way, what's the meaning for each holiday? For example, if the date is on International Labor Day, then the tooptip will display "It is International Labor Day"? Thank you.

How to upload PBI in Community

Best Regards