Forum Discussion

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago
Solved

Dynamic tooltips from measures in matrix

Hi, 
Is there any way / trick or magiv 🙂 to create dynamic tooltips from measures in a matrix?
(different tooltips for every measure)
I tried to implement the suggestion from here, but it doesn't work:
https://en.brunner.bi/post/dynamic-tooltip-pages-in-microsoft-power-bi-for-measure-columns 
 Thank you, Rita.

  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Ritaf1983,

    The reference link config dynamic result based on the category groups. According to your description, it seems like you want to apply these based on measure formulas.

    Have you setting the category group on your measure formulas? If that is the case, you can use Dax calculation group functions to get the current measure name as condition to switch to different results.

    Calculation Groups - SQLBI

    SELECTEDMEASURENAME function (DAX) - DAX | Microsoft Learn

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Ritaf1983,

    The reference link config dynamic result based on the category groups. According to your description, it seems like you want to apply these based on measure formulas.

    Have you setting the category group on your measure formulas? If that is the case, you can use Dax calculation group functions to get the current measure name as condition to switch to different results.

    Calculation Groups - SQLBI

    SELECTEDMEASURENAME function (DAX) - DAX | Microsoft Learn

    Regards,

    Xiaoxin Sheng

  • Hi Ritaf1983 , In a similar situation like you.
    There are 40 measures and I need to show a different name for each measure.
    How did you create the Dax for this ?
    Switch(selectedmeasurename() = "Measure1", "Name 1",
    selectedmeasurename() = "Measure2", "Name 2",
    selectedmeasurename() = "Measure3", "Name 3"
    )
    Thank you