Forum Discussion
Custom Tooltip on Matrix Based on Measure
- 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 .
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.
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 .
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.
Hi there,
By chance you still have the .pbix file? seems to be gone