When you click Show Data in a Waterfall visual that has uses a Breakdown field, the data shown is incorrect.
Here is a simplistic data model -- I encourage you to recreate the issue yourself:
| Year | Product | Sales |
| 2017 | A | 1 |
| 2017 | B | 2 |
| 2018 | A | 3 |
| 2018 | B | 4 |
When you build a waterfall and click Show Data, you'll see the following:
The waterfall itself is correct, but the table at the bottom is not.
Note that the first column (A) is actually the total of each year, and the second column (B) is actually the first value (A) -- i.e., all values are shifted by one column. This is not so easy to notice with very few columns, but when there are many columns, it's obvious.
This is the same in all the waterfall charts in our reports.
This is a serious issue that makes users distrust Power BI.
Comments
- iannedrs on: Error: There is an error in XML document (1, 1).
-
v-xiaoyan-msft
on:
Cannot share PowerBi reorts and dashboards to my o...
-
rayishome
on:
Get External Data: Power BI semantic models throws...
-
v-yetao1-msft
on:
Power BI Desktop April 2024 : Sort by issue. False...
-
v-yetao1-msft
on:
Power BI Service - NetworkConnectionIssue when sav...
-
v-yetao1-msft
on:
Power BI semantic model account sign in for every ...
-
Idrissshatila
on:
Timeline slicer is showing 30 & 31 March under 30 ...
-
v-yetao1-msft
on:
Publish to web url not working
- gfbentes55_sema on: PROBLEM WHEN USE JSON FROM WEB WITH LATITUDE AND L...
- swift_devon on: Error when using AppSource visuals. "Something wen...