cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AJPF
Helper I
Helper I

reorder columns in a matrix

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

3 REPLIES 3
HusnaBanu413
Memorable Member
Memorable Member

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!