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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
sbkrish
Microsoft Employee
Microsoft Employee

How to Sort the Axis in a Chart which is having Month name and uses data from SSAS cube live connect

using SSAS cube live connection, created a chart, used Month Name in the Axis,  but by default sorted alphbetically, but i want it to sort by calendar month wise.

2 REPLIES 2
tonysellars
Advocate II
Advocate II

Typically this sort would be driven by the sorting in the SSAS cube itself.  Make sure that the sort by column property is set up correctly in the SSAS model to sort on a month key value such as 201601, 201602, 201603, etc.  If that checks out, then there might be something else up, but start there.

asocorro
Skilled Sharer
Skilled Sharer

Have you tried specifying the Sort By column?

 

https://msdn.microsoft.com/en-us/library/hh479566.aspx

 

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors