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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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