Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |