Waterfall Chart Issue when filtered

[Anonymous]

Hello,

I have a table that is connected to a calendar table which contains a week ending field.  I have a slicer that a user selects the week ending date they are interested in reviewing (4/6, 4/13, 4/20 ect).  This filters the visuals as desired, however the challenge is my Waterfall chart becomes a single point as there is no previous week within this context.  

For example, in the screenshot below, when week ending 4/6 is selected in the slicer, the watefall should show the total from 3/30 (previous week ending) and the difference over the the dates within the 4/6 range.  I can't think of a way to accomplish this as the measure filters to the context of 4/6.

Any thoughts on how this might be accomplished?

[v-yuta-msft]

@Anonymous ,

You need to select "Less than or equal to" option of the slicer.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi  v-yuta-msft,

That will not work,  the visuals on the page are filtered based on the slicer value (dates within a specific week ending period) which the slicer provides. 

I'm trying to figure out how to dynamically update the Category value based on a range I compute from the selected slicer value?

I'm trying to end up with a chart like this.

I created a measure that calculuates the periods I need:

//Get the value from Week Ending Slicer, if no value, use previous week ending
	VAR EndDate = SELECTEDVALUE('Calendar'[Week Ending], (TODAY() + ( ( 7 - WEEKDAY ( TODAY() ) ) )) - 7)

//Get previous week begin date based on above value
	VAR BeginDate = WeekEndingEnd - 13

But I'm not sure how to pass this as a range to the Waterfall visual (category value). If I can do that, then the measures should calculate and the visual should display as I expect.

[v-yuta-msft]

@Anonymous ,

To interactive a period which is selected in the slicer, you may use ALLSELECTED(Table) or ALLSELECTED(Table[Column]) instead.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Can you provide an example of how this might work?  I am not understanding how this will remove the filter context for the page and only return the previous two periods.

[v-yuta-msft]

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[Anonymous]

Apologies, I had stepped out on vacation shortly after posting.  I'm not certain yet on how to leverage ALLSELECTED(Table) or ALLSELECTED(Table[Column]) and will be investigating this week.