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.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.