Forum Discussion
Convert table structure for waterfall chart
Dear all, I have following table structure with revenues for 2022 and 2023 as well as delta revenues 2023 vs. 2022 per Country. Category Breakdown Revenue 2022 2022 100 Delta Count...
BA_Pete
Super User
Super UserHi Nata,
I think the correct structure within Power Query would be this:
| year | breakdown | revenue |
| 2022 | X | 40 |
| 2022 | Y | 40 |
| 2022 | Z | 20 |
| 2023 | X | 20 |
| 2023 | Y | 20 |
| 2023 | Z | 60 |
You would then use the Waterfall visual with [year] in Category, [breakdown] in Breakdown, and [revenue] in Y-axis.
Pete