ISINSCOPE for Measures?

[campelliann]

Hi there, 

So I have this matrix with the clients on the rows and then several measures on columns (revenue, margin, etc.).

Now I have created a tooltip/chart that when the user hovers over the Table he can see the tendency of the revenue over the months.

But now the user is saying he would like something more dynamic, for instance if he is on the margin column with the cursor, the tooltip should show the margin tendencies over the months. 

Is this even possible?

[amitchandak · Accepted solution]

@campelliann , You need to create a calculation group, that will make it as dimension. You can now use report tooltip to display selected measure

refer if needed

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU