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.
New user here....
How can i pivot data in such a way that waterfall chart has 2019-2023 by account? Thanks!
My data (as an example) looks like this...
Account | Description | Group | 2019 | 2020 | 2023 |
100000 | M&R | Production | 500 | 500 | 800 |
200000 | Salary | Operations | 1000 | 25 | 25 |
300000 | Burden | Sales | 200 | 300 | 400 |
400000 | Contractor | Unified | 100 | 100 | 100 |
500000 | Taxes | Territory | 200 | 200 | 200 |
600000 | Licensing | Etc. | 400 | 500 | 500 |
Would like to look like this
Account | Description | Group | Value | Year |
100000 | M&R | Production | 500 | 2019 |
200000 | Salary | Operations | 1000 | 2019 |
300000 | Burden | Sales | 200 | 2019 |
400000 | Contractor | Unified | 100 | 2019 |
500000 | Taxes | Territory | 200 | 2019 |
600000 | Licensing | Etc. | 400 | 2019 |
100000 | M&R | Production | 500 | 2020 |
200000 | Salary | Operations | 1000 | 2020 |
300000 | Burden | Sales | 200 | 2020 |
400000 | Contractor | Unified | 100 | 2020 |
500000 | Taxes | Territory | 200 | 2020 |
600000 | Licensing | Etc. | 400 | 2020 |
100000 | M&R | Production | 800 | 2023 |
200000 | Salary | Operations | 25 | 2023 |
300000 | Burden | Sales | 400 | 2023 |
400000 | Contractor | Unified | 100 | 2023 |
500000 | Taxes | Territory | 200 | 2023 |
600000 | Licensing | Etc. | 500 | 2023 |
Solved! Go to Solution.
Select first 3 columns and click Unpivot other columns.
Gives you this:
Regards,
Tarun
Select first 3 columns and click Unpivot other columns.
Gives you this:
Regards,
Tarun
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |