Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Below is my source Data:
| Store number | Style | Group | TY Unit | LY Unit | TY INVENTORY | LY INVENTORY |
| 1 | apple | F | 5 | 5 | 8 | 17 |
| 1 | watermelon | F | 7 | 8 | 7 | 14 |
| 1 | blueberry | F | 8 | 7 | 6 | 12 |
| 1 | pear | F | 10 | 4 | 2 | 16 |
| 2 | apple | F | 3 | 6 | 3 | 25 |
| 2 | watermelon | F | 7 | 9 | 23 | 14 |
| 2 | blueberry | F | 6 | 3 | 82 | 9 |
| 2 | pear | F | 5 | 2 | 32 | 8 |
| 3 | apple | NF | 4 | 8 | 20 | 13 |
| 3 | watermelon | NF | 1 | 5 | 23 | 11 |
| 3 | blueberry | NF | 7 | 1 | 32 | 10 |
| 3 | pear | NF | 8 | 2 | 33 | 8 |
| 4 | apple | NF | 2 | 5 | 25 | 9 |
| 4 | watermelon | NF | 6 | 5 | 78 | 8 |
| 4 | blueberry | NF | 6 | 6 | 54 | 15 |
| 4 | pear | NF | 6 | 4 | 32 | 4 |
"TY INV VS LY" and "TY UNIT VS LY" are new measures added that calculate the change. However I can only create a Matrix below by dragging "Group" to the Columns section and "TY INV VS LY" and "TY UNIT VS LY" to the Values section.
I would like to use "TY INV VS LY" and "TY UNIT VS LY" as the group and "F" & "NF" as values names.
Essentially stwitching "Columns" names and "Values" names and group "TY INV VS LY" columns together and "TY UNIT VS LY" columns together.
My ideal table is like this :
Is there a way to achiech this in BI?
Any comments or suggestions would be appreciated!
@Anonymous , if you need to measure the above dimension, you need to create a calculation group
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 60 | |
| 45 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 108 | |
| 108 | |
| 41 | |
| 30 | |
| 27 |