This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 28 | |
| 23 | |
| 22 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 60 | |
| 35 | |
| 28 | |
| 22 | |
| 21 |