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
Super User II
Super User II

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

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

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors