Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
santoshlearner2
Resolver I
Resolver I

Need Help: Show latest month first in matrix instead of last

Hello,

I want to show a trend of sales, using matrix visualizations, say of last x months or based on the user selection, But the issue is the latest months shows on the right hand side alongwith the total next to it, I wanted to show it at the start .  Thank you all in advance. Warm Regards. 

It shows like this              
Employee NameApr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24Total
x100203040506070809010124212616
y40506070405060704050607012672
z90101242901012429010124212474
               
Wanted like this              
Employee NameApr-24Mar-24Feb-24Jan-24Dec-23Nov-23Oct-23Sep-23Aug-23Jul-23Jun-23May-23Apr-23Total
x124212109080706050403020100616
y12706050407060504070605040672
z12421210904212109042121090474
2 ACCEPTED SOLUTIONS
v-tangjie-msft
Community Support
Community Support

Hi @santoshlearner2 ,

 

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

vtangjiemsft_0-1717121079713.png

(2) We can enter data.

vtangjiemsft_1-1717121154852.png

Month-Year Index
Mar-23 14
Apr-23 13
May-23 12
Jun-23 11
Jul-23 10
Aug-23 9
Sep-23 8
Oct-23 7
Nov-23 6
Dec-23 5
Jan-24 4
Feb-24 3
Mar-24 2
Apr-24 1

 

(3) We can then create a model relationship.

vtangjiemsft_2-1717121280303.png

(4) Select Table 2, select the [Month-Year] column, and select Sort by the Indexed Column.

vtangjiemsft_3-1717121362663.png

(5) Create the matrix as shown below.

vtangjiemsft_4-1717121460779.png

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

View solution in original post

Hi 

 

Perfect, thank you for your reply. 

 

Thanks a lot

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

Hi,

You should be able to sort by months in descending order.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-tangjie-msft
Community Support
Community Support

Hi @santoshlearner2 ,

 

According to your description, here are my steps you can follow as a solution.

(1) This is my test data.  

vtangjiemsft_0-1717121079713.png

(2) We can enter data.

vtangjiemsft_1-1717121154852.png

Month-Year Index
Mar-23 14
Apr-23 13
May-23 12
Jun-23 11
Jul-23 10
Aug-23 9
Sep-23 8
Oct-23 7
Nov-23 6
Dec-23 5
Jan-24 4
Feb-24 3
Mar-24 2
Apr-24 1

 

(3) We can then create a model relationship.

vtangjiemsft_2-1717121280303.png

(4) Select Table 2, select the [Month-Year] column, and select Sort by the Indexed Column.

vtangjiemsft_3-1717121362663.png

(5) Create the matrix as shown below.

vtangjiemsft_4-1717121460779.png

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Hi 

 

Perfect, thank you for your reply. 

 

Thanks a lot

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.