Forum Discussion

cristianpark's avatar
cristianpark
Frequent Visitor
6 years ago
Solved

Custom Tooltip on Matrix Based on Measure

Hi guys   I'm trying to do something somehow easy but it seems like is not possible in Power BI (Jan 2020 release). I'm trying to display a help message (on a tooltip) based on column the user is h...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi , cristianpark 

    Try steps as below:

    1.create a table contain a column as below

    2. Then create measures "value" (to instead the field "fixed" and "available") ,and put it into the value of matrix 

     

     

    Value = SWITCH(SELECTEDVALUE('Column'[Column]),"Fixed",AVERAGE('Table'[Fixed]),"Available",AVERAGE('Table'[Available]))

     

     

    3.create page3 as  tooltips page ( make sure the type of tooltip is report page)

    Put  measure "tooltip text" into a card visual in page3

     

     

    Tooltip Text = 
VAR selectedType=SELECTEDVALUE('Column'[Column], BLANK())
RETURN
IF(selectedType<>BLANK(),selectedType, "Nothing")&" Measure: "&[Value]

     

     

    4. it will show as below

     

    Here is a demo .

    pbix attached

     

     

    In addition , you can refer this post if help.

    https://community.powerbi.com/t5/Desktop/Can-I-have-a-tooltip-per-entry-to-a-table/td-p/928605

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi , cristianpark 

Try steps as below:

1.create a table contain a column as below

2. Then create measures "value" (to instead the field "fixed" and "available") ,and put it into the value of matrix 

 

 

Value = SWITCH(SELECTEDVALUE('Column'[Column]),"Fixed",AVERAGE('Table'[Fixed]),"Available",AVERAGE('Table'[Available]))

 

 

3.create page3 as  tooltips page ( make sure the type of tooltip is report page)

Put  measure "tooltip text" into a card visual in page3

 

 

Tooltip Text = 
VAR selectedType=SELECTEDVALUE('Column'[Column], BLANK())
RETURN
IF(selectedType<>BLANK(),selectedType, "Nothing")&" Measure: "&[Value]

 

 

4. it will show as below

 

Here is a demo .

pbix attached

 

 

In addition , you can refer this post if help.

https://community.powerbi.com/t5/Desktop/Can-I-have-a-tooltip-per-entry-to-a-table/td-p/928605

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

cristianpark's avatar
cristianpark
Frequent Visitor
6 years ago

Thank you Greg_Deckler and v-easonf-msft for such complete answers.

 

Bookmarks approach Greg_Deckler proposed is an easy way to do it without affecting underlying data model (the default option for us was just to put help text below table so bookmarks are a good addition to it).

 

Creation of table as v-easonf-msft is cool, that way you can customize tooltip as needed and is more scalable modifying value measure for adding columns with custom tooltip. The only caveat I saw is that you'll loose ability of sorting by each column on matrix and in my case, that's a must.

 

It'll be great to be able to somehow identify a measure within a cell but workarounds are good enough for now.

 

Thank you!