Forum Discussion

Anthony_W's avatar
Anthony_W
Helper I
7 years ago

Wrange data for Waterfall Chart

Hi All,   I am trying to wrangle my data into the format required for a waterfall chart. I can calculate a waterfall chart that just shows the difference in values from zero, but I would like to in...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anthony_W ,

 

I couldn't reproduce the senario below, if possible, could you please provide some screenshot(Do mask the sensitive data) or provide a sample file?

 

"If I plot a waterfall chart using Year-Quarter and the difference column as shown in the table, than the waterfall chart looks OK. However, if I introduce a filter for say a year such that Year-Quarter starts at 2021-Q1, then a difference of -0.81 is calculated for 2021-Q1 and the waterfall chart start from zero whereas I would prefer this to start at 38.28, and then follow the difference column then."

 

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.

Anthony_W's avatar
Anthony_W
Helper I
7 years ago

v-yuta-msft,

see link below for an example sample file.

Link to Waterfall example

 

The waterfall chart is OK when a year isn't selected. When a year is selected, the waterfall chart starts at zero, rather than the first ash value. Hope that makes sense!

 

Cheers,

 

Anthony