Dear All,
I have created a report with several tables and a chart using fields as parameters so I can switch easily between the 4 different values. There is also a date slicer on the page. However, for one of the values in the chart I want every filter to remain except the date slicer which I want to show different date values (the tables show historic dates as per the date slicer but, for this one specific chart value, I want to show different date values - future dates). I can achieve this by unlinking the chart interactions but this then means it’s incorrect for the other field values which I still want to respond to the date slicer. I therefore need to do this via DAX.
I’m not sure if it’s relevant to the issue but the measure is based on a secondary date relationship ([FINAL DELAY] to [Date]) and the data is filtered to only include specific rows (in this case when dates in V_TIMESTAMP are in Oct 23 - the intention is that this will eventually become a dynamic value based on a slicer selection but that’s a problem for another day). I’m sure this would be achievable using some combination of All, Allexcept, keepfilters, etc, but so far I cannot get this to work. Any ideas anyone?
The current base formula is as follows:
Backlog (Chart) =
CALCULATE(sum(Backlog[NET_VALUE_BALANCE_CHF]),
FILTER(ALL(Backlog[V_TIMESTAMP]), Backlog[V_TIMESTAMP] >= DATE(2023, 10, 1) && Backlog[V_TIMESTAMP] <= DATE(2023, 10, 31)),
USERELATIONSHIP(Backlog[FINAL_DELAY], 'Calendar'[Date])
)
As mentioned, this works if the chart/date slicer interaction is removed. The intention is that the above measure still works with the interaction still enabled.
Thanks in advance
