This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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 May 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 |
|---|---|
| 32 | |
| 25 | |
| 24 | |
| 22 | |
| 13 |
| User | Count |
|---|---|
| 61 | |
| 47 | |
| 27 | |
| 24 | |
| 19 |