Forum Discussion
alfBI
Responsive Resident
Responsive ResidentMatrix with multiple values for a column - How to retrieve cell properties
Hi, We have prepared a matrix table with 1 item on the column (row Name), 1 item on the column (Col Name) and two values (measure A & B). We would like to create a custom tooltip that displays th...
Hi alfBI, I don't think it's possible... Both measures are evaluated in a defined filter context (i.e. row3 and col2). While hovering between values 11 and 2 the filter context of PowerBI is not changing, which means both are evaluated. You can create a tooltip to show values of both or only one, but this one should be defined in advance (always Measure A or always Measure B).
I've tried to play around with SELECTEDMEASURE() and similar functions but didn't find a way to obtain the desired result.
If you find a solution, please tag me as I'd like to learn how to do it!
AnalyticPulse
Solution Sage
Solution Sagei suggest creating a separate tooltip table for the tooltip and use the custom tooltip for meeting this requirement