Display values in Tool Tip.

[NithinBN]

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

[Greg_Deckler · Accepted solution]

@NithinBN - Create a measure for your tooltip like this:

Measure =
  CONCATENATEX(
    DISTINCT(
      SELECTCOLUMNS('Table',"ID",[ID])
    ),
    [ID],","
  )

Use that for your Tooltip. 

[amitchandak]

@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