Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
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
Solved! Go to Solution.
@NithinBN - Create a measure for your tooltip like this:
Measure =
CONCATENATEX(
DISTINCT(
SELECTCOLUMNS('Table',"ID",[ID])
),
[ID],","
)
Use that for your Tooltip.
@NithinBN - Create a measure for your tooltip like this:
Measure =
CONCATENATEX(
DISTINCT(
SELECTCOLUMNS('Table',"ID",[ID])
),
[ID],","
)
Use that for your Tooltip.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |