Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Waterfall Chart Issue when filtered

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?

Need Help

6 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi  

       

       

      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's avatar
        v-yuta-msft
        Community Support
        7 years ago

        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.