Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Yearly variation -> waterfall

Hi everyone,

 

I calculated my yearly growth variation and I wanted to visualize it into a waterfall. 

 

How can I do for making 2021 not appear in my waterfall since I haven't selected it in my filter? 

 

 

Thanks for your answer.

Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Ensure that you have dragged Year from the same table that you dragged the Year from into the slicer.

5 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Ensure that you have dragged Year from the same table that you dragged the Year from into the slicer.

  • negi007's avatar
    negi007
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Anonymous Please check if interaction between your slicer and visual is enabled. Ideally, your selection in the filter should change the selection in the visual as well. 

     

     

     

     

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous 

     

    Are you using the Year column from the same table into the slicer and waterfall chart? If not, please use the Year column from the same table or create a relationship between two tables so that the Year column in one table is able to filter the other table based on the relationship.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks to all, now it's fine !