Forum Discussion

skl2023's avatar
skl2023
Regular Visitor
2 years ago
Solved

Power BI tooltips

Hi,

 

I have a matrix in Power BI and am trying to get custom tooltips for each row to show a different definition. Is this possible?

 

e.g. I have the below table. For all rows in Measure 1 I want to show definition 1 as the tooltip.

For all rows in Measure 2 I want to show definition 2 as the tooltip.

 

 Product 1Product 2Product 3
Measure 1345
Measure 2256
Measure 3982

 

Thanks,

 

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anand24 , Greg_Deckler , thank you for your quick replies, I'll add further .

    Hi skl2023 ,

    Please follow these steps:

    1.Create a new tooltip page and place a card visual object.

    2.Use the following DAX expression to create a measure

    Measure = 
    VAR _a = SELECTEDVALUE('Table'[Type])
    VAR _b = SWITCH(TRUE(),
    _a = "Measure 1",1,  //Replace the definitions you need
    _a = "Measure 2",2,
    _a = "Measure 3",3)
    RETURN _b

    3.Setting up a tooltip page for the matrix

    4.Final output

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anand24 , Greg_Deckler , thank you for your quick replies, I'll add further .

    Hi skl2023 ,

    Please follow these steps:

    1.Create a new tooltip page and place a card visual object.

    2.Use the following DAX expression to create a measure

    Measure = 
    VAR _a = SELECTEDVALUE('Table'[Type])
    VAR _b = SWITCH(TRUE(),
    _a = "Measure 1",1,  //Replace the definitions you need
    _a = "Measure 2",2,
    _a = "Measure 3",3)
    RETURN _b

    3.Setting up a tooltip page for the matrix

    4.Final output

     

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    skl2023 That should be possible by placing the appropriate measure in the tooltip fields for each tooltip page. That said, not sure I am following exactly what you are trying to do.

  • skl2023 ,
    Create a new table with Measure and its definitions. Map this table to above table. Create a new tooltip page and pull definition field in it and use this page as tooltip in yout table/matrix.