CODEWITHSUNDEEP
powerbitooltip
Makarand Padhye
Makarand Padhye

Reputation: 59

How to give different tooltips to different columns in Power BI

I have created table in Power BI. While giving tooltips, I want to display Tooltip-1 to 2nd column and Tooltip-2 to 3rd column as shown in the image. How to do this ?

enter image description here

enter image description here

Upvotes: 2

Views: 16670

Answers (2)

Sero42
Sero42

Reputation: 73

In a matrix visual you can do this by putting the tooltip visuals for every column one above the other on a single tooltip page.

  • Now you change background settings of the tooltip visuals to 100% transparency.
  • Then you make sure that text elements are only visible if the desired column is hovered over with a measure like (used as formating measure for font color) 
    Transparency =
IF(
    SELECTEDVALUE(tabl1[column1]) = "column title in matrix",
    "black",
    "#FFFFFF00" // 00 means 100% transparency
)
  • Charts like line charts etc. for their graphs need to use a logic like 
    Conditional Sum =
IF(
   SELECTEDVALUE(Table1[Column1]) = "Column title in matrix",
   SUM(Table2[Column1]),
   BLANK()
)

Upvotes: 3

RF1991
RF1991

Reputation: 2265

I think the only way to solve your problem is Power BI report page tooltip.

duplicate your page step 1

in duplicated page remove all other visual except your table make sure that table is in position of top left and make sure it is visible step 2

in page information activate tooltip step 3

in page size,select type of page tooltip(it is not necessary important but it helps to have better tooltip) step 4

go back in tooltip section of your table visual, set the type of report page step 5

set the page to the page you have duplicated step 6

enter image description here

Upvotes: -1

Related Questions