Custom Tooltips with 2 visual working on different filter

[Anonymous]

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 hover.

Attached below is a screenshot for a better understanding:

The output that I am getting currently:

The output which is expected:

@lbendlin @parry2k  @amitchandak  @arthur89 

Thanks,

Mohit 

[Anonymous]

Hi @amitchandak , thanks for sharing the link, I tried to achieve the way it has been suggested. But the only difference between my scenario is that my data is only getting filtered on year-month so if I turn it off and pass separately still it will behave the same way because the card need to get filtered but the line graph does not need to be filter on month.

[amitchandak]

@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]

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

[amitchandak · Accepted solution]

@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