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.
Hello all,
I have a simple matrix showing three variables (number of starts "S", number retained "R" and number passed "P") split by two other variables (curriculum area and age group).
It currently looks like this:
Age group 16-18 19+ Total
Curr Area S R P S R P S R P
Education 10 8 6 15 12 10 25 20 16
Arts 20 13 9 45 40 35 65 53 44
Computing 30 25 21 10 5 3 40 30 24
Total 60 46 36 70 57 48 130 103 84
I would like, if possible, to reorder the columns so it looks this:
Age group S R P
Curr Area 16-18 19+ 16-18 19+ 16-18 19+
Education 10 15 8 12 6 10
Arts 20 45 13 40 9 35
Computing 30 20 25 5 21 3
Total 60 70 46 57 36 48
Is this possible? I don't need the Total column in the new version.
Thank you
Hi @AJPF
Please check https://cloudbi.com.au/calculation-groups-use-cases-power-bi-matrix/ this might help you
Regards,
Husna
I've read Ali's post but, unless I'm missing something, I'm not sure that it helps.
His matrix only had one values variable - Sales Amount - but mine has three.
Hi @AJPF ,
Would you please show us sample pbix ?Then we can help you more accurately.
Best Regards,
Dedmon Dai
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |