Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Custom Tooltips with 2 visual working on different filter

Hi Team,   I am trying to find a solution where I am trying to build a custom tooltip where the line graph should be consistent and the monthly card for sales keeps changing based on the month we h...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    Anonymous , There is an option to keep all filters. You can turn off that, then it will not pass the month year to tooltip

     

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

     

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

Anonymous , a Disconnected table or an independent table can be used.

 

I am assuming in the tooltip I will use the disconnected table on the axis

 

Auto Net = CALCULATE( CALCULATE([Net], FILTER(Sales, Sales[Date] = max('Date Auto'[Date]))), filter( 'Date Auto', 'Date Auto'[Date] <= Max(Date[Date]) ) )

 

Date Auto is disconnected and can be used on axis of tooltip

 

Modify the second filter as per need

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amitchandak , thanks for the idea of a disconnected table with that logic it worked out. Not required to use any separate DAX.