Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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!
Data table
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 46 | |
| 43 | |
| 39 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 68 | |
| 65 | |
| 31 | |
| 28 | |
| 24 |