Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
this is related to the Waterfall Chart Tutorial posted here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-waterfall-charts/
Just want to make sure I am seeing this "right".
At Step 5 the Waterfall chart is created with month JAN as a negative starting point and month FEB just a very small positive value, so month MAR is still starting from a negative value.
At step 6 and 7 we add the breakdown by Territory but when looking at the Waterfall chart above step 8 - my opinion - the values are incorrect.
So month JAN starts with the negative value, but the breakdown values - even though negative - are going up - and now month FEB is close to the zero line and month MAR is starting with a positive values.
Is this just me or is this wrong ?
Thanks
Ingo Hilgefort
So does Power BI team give the solution on how to remove the total column? or hide ?
Hello everyone,
this is related to the Waterfall Chart Tutorial posted here:
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-waterfall-charts/
Just want to make sure I am seeing this "right".
At Step 5 the Waterfall chart is created with month JAN as a negative starting point and month FEB just a very small positive value, so month MAR is still starting from a negative value.
At step 6 and 7 we add the breakdown by Territory but when looking at the Waterfall chart above step 8 - my opinion - the values are incorrect.
So month JAN starts with the negative value, but the breakdown values - even though negative - are going up - and now month FEB is close to the zero line and month MAR is starting with a positive values.
Is this just me or is this wrong ?
Thanks
Ingo Hilgefort
Hi @ihilgefort,
A waterfall chart shows a running total as values are added or subtracted. It's useful for understanding how an initial value (for example, net income) is affected by a series of positive and negative changes.
In my opinion, both charts(with or without breakdowns) make sense to me., as a waterfall chart just shows a running total as values are added or subtracted(in this case, the values are Total Sales Variances). See underline data below.
Regards
Hello @v-ljerr-msft
Thanks for your response and I understand what a waterfall chart does, which I still think that it is slighly incorrect.
let me explain the scenario:
the complete scenario is here:
At step 5 we have this waterfall chart:
You can see that JAN has a negative value and that FEB starts at around 0.4M negative and then MAR has a large positive values that goes up to 0.5 M positive.
In Step 6 and 7 we then add the Territory Breakdown and - my opinion - what the waterfall chart should be doing is to break down the "parent" into the values.
but look at what it does:
so I hope that explains it and I still think that the Waterfall chart is doing the breakdown incorrect.
What it should be doing is:
Thanks
Ingo Hilgefort, Visual BI
HI,
how can this be raised with Microsoft ?
the current "breakdown" option in the Waterfall chart is misleading as the values change for the parents.
Ingo
Hi @ihilgefort,
In this scenario, I would suggest you add it as an idea on Power BI Ideas forum. If there are enough votes, the Product Team will evaluate and take good consideration about it.
Regards