Custom tooltip for each row of the table

[AbbasG]

Hi All,

Is it possible to add a custom tooltip for each row of the table?

[MFelix]

Hi @AbbasG ,

When you refer a custom tooltip is to have a different layout for each row? Or only different values?

If you are refering to diferent layouts the only way I can remember is to created several condittional format for the colours similar to this:

COLOUR 2019 BACKGROUND = IF(SELECTEDVALUE('Table'[year]) = 2019, "#FFFFFF", "#FFFFFF00")
COLOUR 2019 = IF(SELECTEDVALUE('Table'[year]) = 2019, "#000000", "#00000000")

COLOUR <> 2019 BACKGROUND = IF(SELECTEDVALUE('Table'[year]) <> 2019, "#FFFFFF", "#FFFFFF00")
COLOUR <> 2019 = IF(SELECTEDVALUE('Table'[year]) <> 2019, "#000000", "#00000000")

Be aware that in my case I selected the black for everything but if you want to have bars in different ways you need to create different options.

Then on visuals you need to present you need to set the differenct colour options accordingly to what you need in this case what I have is when 2019 is selected then the values are black otherwise transparent in the other years is the same thing now I use a card for 2019 and a bar chart for the other years result is :

You can tweak this using a switch formula for example or a table with the selections of colour you need, but the overall need that you have to do is to setup the colours on each of the specific tooltips based on the colour or transparent for all visualizations.

[AbbasG]

@MFelix thank you for the response. I need different values for each row.

For example, I have a list of products with models and I need to see the last cost in the tool-tip for each model.

[MFelix · Accepted solution]

Hi @AbbasG,

Sorry for the miss understanding.

That is exactly what they custom tooltips do. Do you have any metric that does teh calculation of the last cost?

If you do you just need to place it on the tooltip page and the context of the product will pass trough and show the specific value. 

[AbbasG]

@MFelix Thank you for your time, it works for me.