Forum Discussion
NithinBN
Helper II
6 years agoDisplay values in Tool Tip.
Hello,
This is my Table and have made chart out of that table.
| ID | Product | Value |
| P-01 | Bike | Green |
| P-02 | Bike | Yellow |
| P-03 | Bike | Green |
| P-04 | Bike | Red |
| P-05 | Bike | Green |
| P-06 | Clothing | Yellow |
| P-07 | Clothing | Green |
| P-08 | Clothing | Red |
| P-09 | Clothing | Red |
| P-10 | Clothing | Green |
| P-11 | Others | Yellow |
| P-12 | Others | Yellow |
| P-13 | Others | Red |
| P-14 | Others | Green |
| P-15 | Others | Green |
Tool Tip
Here in tool tip its only showing P-11, how to show all the values that made that bar, in this case both "P-11" and "P-12".
Thanks
NithinBN - Create a measure for your tooltip like this:
Measure = CONCATENATEX( DISTINCT( SELECTCOLUMNS('Table',"ID",[ID]) ), [ID],"," )Use that for your Tooltip.
2 Replies
- amitchandak
Super User
NithinBN , In case you take it tooltip, it will show only the first value. You can create a tooltip page and use it.
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips/last
- Greg_Deckler
Community Champion
NithinBN - Create a measure for your tooltip like this:
Measure = CONCATENATEX( DISTINCT( SELECTCOLUMNS('Table',"ID",[ID]) ), [ID],"," )Use that for your Tooltip.