ALL Dax problem

[KimC]

Hello,

I have a dashboard which has YTD sales Nov to April Q1-Q2 (using offset function to exclude current month) and ALL to ignore quarter filter which works fine in a card

I want to have a tooltip which looks like this

My problem is when I select Q3 on the slicer, my tooltip no longer works (YTD number is fine)

Any suggestions how to get the tooltip to show Q1/Q2 using dax when I select Q3?

ALL dax problem.pbix (88.5 KB)

[AntrikshSharma]

Cumulative Dax Pattern not working on tooltip with disconnected tables

@BrianJ & @BINavPete Is this what we are trying to achieve? VSB6_EDNA.pbix (6.8 MB) [image] If yes, then the column on the slicer needs to be from Disconnected Dates table, as the Filter from the Column Chart(Date Table) to the Tooltip is going to be applied first because of which you are not able to get all the dates between the specified period. [image]

[KimC]

Thankyou for the feedback @AntrikshSharma. I was mainly checking if it could be done easily with DAX but I think it will be much simplier to use Edit Interactions and disable the charts for the qtr slicer.