cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gussiie Frequent Visitor
Frequent Visitor

Need help swapping columns in Matrix Table

Hi

 

Can someone please tell me how I swap 2017 and 2018 in the date column in a matrix table? 

 

Currently 2017 is showing first. I want 2018 to show first, followed by 2017. 

 

Please see imgur here: https://imgur.com/a/GZOSifR    (try coping and pasting into search browser)

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Need help swapping columns in Matrix Table

Hi @gussiie,

 

Normally, matrix column header is not supported for sort by in power bi currently.

 

You could try this workaround below and have a reference of this blog.

 

1. Create a table with date and index

2. Create the relationship between the tables and create the calculated column year.

3. Sort calcualted column year by Index.

4. Create the matrix with calculated column year and Date hierarchy Quarter as column.

 

Capture.PNG

 

More details, you could refer to this attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 REPLIES 7
Community Support Team
Community Support Team

Re: Need help swapping columns in Matrix Table

Hi @gussiie,

 

Unfornately, I cannot open your shared URL, it seems to be a 404 page. 

 

In addition, I'm a little confused about your requirement. Do you want to show the matrix with 2018 data first then show 2017 data?

 

If it is, you could create the date Slicer with Year column to filter the matrix data. 

 

In addition, you also could use Bookmark feature to achieve your requirement.

 

If you still need help, please share some data sample and your desired output so that we could help further on it.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gussiie Frequent Visitor
Frequent Visitor

Re: Need help swapping columns in Matrix Table

Hi 

 

Thanks for your response. I am not sure what you mean by slicer but I simply want to swap the below picture around so 2018 is first.

 

Power BI Question.png

 

Can you please direct me on how to do this. 

 

Thanks. 

Community Support Team
Community Support Team

Re: Need help swapping columns in Matrix Table

Hi @gussiie,

 

It seems that you want to get the output like below.

 

Untitled.png

 

If it is, please click the more option and select Sort Descending, check if this could achieve your requirement.

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gussiie Frequent Visitor
Frequent Visitor

Re: Need help swapping columns in Matrix Table

Hi 

 

This does not work. It will only sort the rows or values. It does not sort the columns or give me an option to sort date by descending. 

 

2018-10-17_0908.png

 

Are there any other ways?

Community Support Team
Community Support Team

Re: Need help swapping columns in Matrix Table

Hi @gussiie,

 

Normally, matrix column header is not supported for sort by in power bi currently.

 

You could try this workaround below and have a reference of this blog.

 

1. Create a table with date and index

2. Create the relationship between the tables and create the calculated column year.

3. Sort calcualted column year by Index.

4. Create the matrix with calculated column year and Date hierarchy Quarter as column.

 

Capture.PNG

 

More details, you could refer to this attachment.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gussiie Frequent Visitor
Frequent Visitor

Re: Need help swapping columns in Matrix Table

Thank you so much!

 

I love this community!

Community Support Team
Community Support Team

Re: Need help swapping columns in Matrix Table

Hi @gussiie,

 

You're welcome!Smiley Very Happy

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.