cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
saivenkat Member
Member

Months not sorting in a graph

Hi All

I have a direct query and it doesnt allow ORDER BY . Inmy graph i have months randomly places and not in an order , is there a way to fix this please see the screen shot.Capture715.PNG

 

10 REPLIES 10
Super User
Super User

Re: Months not sorting in a graph

What field are you using for month on your X axis? 

 

If it's some sort of calendar/date dimension, select that field in the Fields pane, and in the Modeling ribbon click Sort by Column to sort it by the Month Number.

saivenkat Member
Member

Re: Months not sorting in a graph

Thanks its a field called MOnth Name from the date dimension , i have no clue what what you asked me to i cannot find a ribbon can you please send me a screen shot?

Thanks

tex628 New Contributor
New Contributor

Re: Months not sorting in a graph

image.png

Highlighted
saivenkat Member
Member

Re: Months not sorting in a graph

Thanks Tex628 no lu k with that.

Super User
Super User

Re: Months not sorting in a graph

There is a bug right now with the Sort by Column button.  If you select a field and it shows as greyed out, but then select a different field and back to the first one, it sometimes becomes available.

 

 

Was your issue with the Sort by Column button, or it just didn't fix your graph?  If so, you may need to sort your X axis the other way.  Right now it looks like it's displaying months in backward chronological order, which should be fixable.  In the top right of the visual, can you find an option to sort ascending? 

saivenkat Member
Member

Re: Months not sorting in a graph

had both the issues, first the sort icon was greyed out, next i did like you said and applied the sort , the months are still showing in a random manner , not even backward order 

currently its showing as June march may april july 

Super User
Super User

Re: Months not sorting in a graph

Huh. Weird.

 

Making the months sort by month number should have fixed the issue. Can you share a .pbix file for this?  If you can't due to data sensitivity, can you try recreating this with super basic dummy data and send us that?  

saivenkat Member
Member

Re: Months not sorting in a graph

thanks i know it is a stupid question but is the report itself a .pbix file?

Super User
Super User

Re: Months not sorting in a graph

Yeah. Power BI uses .pbix as the file type, just like word uses .docx.  

 

If you upload the report to a file sharing service (Dropbox, Google Drive, OneDrive, etc) and share a link here, we can play with it and see if we can fix the issue.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 330 members 3,912 guests
Please welcome our newest community members: