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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 66 | |
| 47 | |
| 43 | |
| 26 | |
| 19 |
| User | Count |
|---|---|
| 196 | |
| 127 | |
| 102 | |
| 67 | |
| 49 |