Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |