Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi there,
I am relatively new to Power BI and I am looking for a bit of help with Tooltips.
I have managed to set up a tooltip to show another variable when an entry in the table is moused over.
However, I am looking to see if its possible to have another variable when I mouse over another column in the table?
Each column in the table is a different variable which is a score out of 5
The information in the tooltip is the reason why that score was given and comes from another variable
Any help would be greatly appreciated
Thanks,
Chris
Solved! Go to Solution.
Hi @Anonymous ,
If your data is similar with the following:
we can create a column header table, then use matrix visual to meet your requirement:
column header table:
ColumnHeaderTable = {"Column1","Column2","Column3"}
Value measure in matrix visual:
MeasureInMatrix = SWITCH(SELECTEDVALUE(ColumnHeaderTable[Value]),"Column1",SUM('Table'[Column1]),"Column2",SUM('Table'[Column2]),"Column3",SUM('Table'[Column3]))
Tooltips measure which will output different value depens on the value column header:
Tooltips = SWITCH(SELECTEDVALUE(ColumnHeaderTable[Value]),"Column1","Tooltip for Column1","Column2","Tooltip for Column2","Column3","Tooltip for Column3")
Best regards,
Here i one use case if i have rows columns in slicer, i need tooltip for only "C" value not when hover on A or B.
Only when i select C value from slicer and i need tooltip on column.
Hi @Anonymous ,
If your data is similar with the following:
we can create a column header table, then use matrix visual to meet your requirement:
column header table:
ColumnHeaderTable = {"Column1","Column2","Column3"}
Value measure in matrix visual:
MeasureInMatrix = SWITCH(SELECTEDVALUE(ColumnHeaderTable[Value]),"Column1",SUM('Table'[Column1]),"Column2",SUM('Table'[Column2]),"Column3",SUM('Table'[Column3]))
Tooltips measure which will output different value depens on the value column header:
Tooltips = SWITCH(SELECTEDVALUE(ColumnHeaderTable[Value]),"Column1","Tooltip for Column1","Column2","Tooltip for Column2","Column3","Tooltip for Column3")
Best regards,
Thanks, i loved this. It lets you display data on a matrix without unpivot data, and use some of the advantages of a matrix.
I used it to show previous month value on certain columns, and on others that says if it the values were below the target, what that target value was.
I have a matrix visual, each column must show different tooltips, however columns here are described as a result of measures (not table columns). In this case how to create tooltips that will show different information for different columns?
My data is similar to that format, so I will give it a shot.
From the images I posted, there is a slicer which reduces the entries into the table.
For this method that you explained, I assume that I should only have one entry in the table for the tooltip to work?
Thanks,
Chris
Hi @Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
Hi @Anonymous ,
It can work for multi columns and rows, each columns can show different tooltips, if you want show different tooltips for each row, we need to modify the measure for tooltips
Best regards,
Hi @v-lid-msft
Thanks for your solution. I have replicated it and it is working as you indicated. However, I am looking for similar solution, but for different tooltips for each column and row. Do you please have the modified version of the measure for tooltips in such case?
On the other hand, as my matrix is quite big, is it possible to get the tooltip texts from another variable(s) in the data, but each column and row have different texts as mentioned above?
Hope to hear from you soon,
With thanks in advance
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
121 | |
112 | |
59 | |
58 |