Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |