Forum Discussion

alfBI's avatar
alfBI
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Matrix 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...
Need Help
  • Sergii24's avatar
    Sergii24
    2 years ago

    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!

Sergii24's avatar
Sergii24
Icon for Super User rankSuper User
2 years ago

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!