cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
LaurenceSD
Helper II
Helper II

Ignore Date Filters Measure

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

 

LaurenceSD_0-1621427918492.png

 

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

 

LaurenceSD_2-1621428132158.png

 

Thanks

 

 

1 ACCEPTED SOLUTION
DataInsights
Super User II
Super User II

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

View solution in original post

1 REPLY 1
DataInsights
Super User II
Super User II

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

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors