Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a matrix with a bunch of measures as values. I want to divide it by month and I am able to, just not in the format I need. currently I have something like this one on my matrix. I put the month in the columns field and all the measures in the values field.
Jan | Jan | Jan | Jan | Jan | Feb | Feb | Feb | Feb | Feb | |
Measure 1 | Measure 2 | Measure 3 | Measure 4 | Measure 5 | Measure 1 | Measure 2 | Measure 3 | Measure 4 | Measure 5 | |
item1 | ||||||||||
item2 | ||||||||||
item3 | ||||||||||
item4 |
I want my matrix to look like this:
Measure 1 | Measure 1 | Measure 2 | Measure 2 | Measure 3 | Measure 3 | Measure 4 | Measure 4 | Measure 5 | Measure 5 | |
Jan | Feb | Jan | Feb | Jan | Feb | Jan | Feb | Jan | Feb | |
item1 | ||||||||||
item2 | ||||||||||
item3 | ||||||||||
item4 |
I am able to do this easily on pivot tables on excel because an extra field on on the columns field appears representing everything in the values field but I can't seem to find an equivalent function on power BI.
@looraainne , the calculation group can help
refer to my video for that
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
HI @amitchandak Thanks for your reply!
currenty trying to follow your video, it looks like it has exactly what I need. I am running into this error, I tried to follow the logic with my own naming convention but I am receiving this error. I can't find what I am doing wrong here
Check out the November 2023 Power BI update to learn about new features.