Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
91 | |
88 | |
35 | |
35 |
User | Count |
---|---|
152 | |
99 | |
82 | |
63 | |
54 |