Forum Discussion
Customized Table / Matrix Visualization with YoY Calculations
Hello!
I'm working with the following data table example and was hoping for feedback / insights into creating the following? I'd like for my audience to quick and easily see the YoY calcs in the table / matrix.
Current table / matrix in PowerBI:
| Year | Category Name | Revenue | Expenses |
| 2023 | Category 1 | 6 | 5 |
| 2022 | Category 1 | 5 | 6 |
| 2023 | Category 2 | 7 | 6 |
| 2022 | Category 3 | 8 | 5 |
How I'm looking to transforrm the visualization:
| Year | Category Name | Revenue | Expenses |
| 2023 | Category 1 | 6 | 5 |
| 2022 | Category 1 | 5 | 6 |
| YoY Change | $1 | ($1) | |
| 2023 | Category 2 | 7 | 6 |
| 2022 | Category 3 | 8 | 5 |
| YoY Change | ($1) | $1 |
Thank you in advance!
2 Replies
FreemanZSuper User
hi Anonymous
the first table, is it data table or table visual?