Ignore Date Filters Measure

[LaurenceSD]

Hi,

I've got a report where i'm looking a current year and the last 2 years. I've filtered the page to be at the start of the current FY & then used SAMEPERIODLASTYEAR to get the prior year figures. However I'm now wanting to add in a Stacked 100% chart to show Guest segmentation by year, but as it's not possible to apply a legend to multiples values, I need to get a formula, that'll bring in all bookings, with the FY as the axis and the Segment as the legend. I've tried ALL and ALLSELECTED, but I'm not getting any joy.

Here's what I have at the moment

& here is what I'd like to have on that same page - is this feasible?

Thanks

[DataInsights · Accepted solution]

@LaurenceSD,

See the solution below:

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/ 

Excerpt:

It is worth remembering that the selection of the values to show on the axis is independent from the measure. If a slicer is filtering one month, there is no way to show additional months from the same table on either the rows or the columns (or the X-axis, as in the example). Therefore, we must create a separate table that is not subject to filtering from the slicer. This way, columns from that table show all the rows, and we can control their visibility through a measure.