Forum Discussion
Waterfall Chart Issue when filtered
Community SupportAnonymous ,
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.
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 - 13But 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.
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
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.