Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

0

ISINSCOPE not working in Tooltips

Hi!

When I'm building a matrix with a measure containing ISINSCOPE it works perfectly for that hierarchy, but when I place the same measure in the Tooltip and try to get it to pop-up while hovering it shows nothing. The Tooltip is just blank.

 

Is it supposed to be like this? Or is it a bug?


The reason I want it is to show different information with the tooltip dependent on the hierarchy level. This can be done with HASONEFILTER pretty nicely but as soon as the level below only has one value the hierarchy above shows wrong information.

______________________________________

Example on measure I've tried:

Measure = 

IF(
    ISINSCOPE(Transaction[Transaction])
    ,1 //Changed for measure
    ,0 //Changed for measure
    )
)


______________________________________

Problem with HASONEFILTER Example:

Level 1 is Cost Center

      Tooltip should show all transactions under it

 

Level 2 is each transaction

      Tooltip should show information about the transaction

 

If there is only one transaction under a Cost Center, then the hover above Cost Center will show the information that is needed on Level 2 not Level 1.

Status: Delivered

Hi @Unell ,

When you create a new page as tooltip, the result is static, just is the data in the page, it has not context with the value in the matrix.

 

Best regards,

Community Support Team_yanjiang

Comments
v-yanjiang-msft
Community Support
Status changed to: Needs Info

Hi @Unell ,

Do you mean conditional formatting in Tooltip, in my side it's not supported in matrix visual. Could you please explain more?

vyanjiangmsft_0-1680589674025.png

Best regards,

Community Support Team_yanjiang

Unell
Regular Visitor

Hi Yanjiang!

If I make a new page that's the tooltip, the measure won't work as it did while being a part of the matrix.

 

It seems to me that the function ISINSCOPE does not work for tooltips in general.

 

Unell_0-1680590321052.png

The picture shows the exact same measure but shows a 1 in the matrix and 0 while hovering over the same cell.

______________________________

test =
IF(
    ISINSCOPE(Investment[Investment])
    ,1
    ,0
)
v-yanjiang-msft
Community Support
Status changed to: Delivered

Hi @Unell ,

When you create a new page as tooltip, the result is static, just is the data in the page, it has not context with the value in the matrix.

 

Best regards,

Community Support Team_yanjiang

Unell
Regular Visitor

Thank you for the fast replies!

 

Will have to rethink my approach then.

Best Regards
Unell

Jojo197
Helper I

Hi @Unell

I'm having the same issue, were you able to find a workaround?

 

Thanks,

Jonathan