Yearly variation -> waterfall

[Anonymous]

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.

[Anonymous]

Thanks to all, now it's fine !

[Ashish_Mathur]

You are welcome.

[v-jingzhang]

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.

[Ashish_Mathur · Accepted solution]

Hi,

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

[negi007]

@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.