Forum Discussion
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 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 , 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
4 Replies
- amitchandak
Super User
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
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
Hi amitchandak , thanks for the idea of a disconnected table with that logic it worked out. Not required to use any separate DAX.