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/...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.