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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
jakeryan56
Advocate II
Advocate II

Date sort issue with visual

I have data coming from two different sources (SalesDataFY17Q3 and SalesDataCurrent) into a combined query (SalesData). One of the sources is data from last quarter (October, November December) and the other is the current quarter (Jan, Feb, Mar).
I have created a visual for trends of measures over time. All the data displays correctly but when I "Sort by month" it doesn't sort them in the correct order as seen in the screenshot below.
Any ideas?

P.PNG

5 REPLIES 5
Phil_Seamark
Microsoft Employee
Microsoft Employee

Hi @jakeryan56

 

I don't thnk the screenshot worked, sorry.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Oops, can you see it now?

Hi @jakeryan56,

 

Have you tried the solution provided above? Does it work in your scenario? If you still have any question, feel free to post it here. Smiley Happy

 

Regards

Hi

I suspect you need to add a year component. So change 'January' to 'January 17'. This includes the underlying column you may be using as a 'sort by column'.

Do you have a Calendar table in your model?

To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

If you leave the data grouped as 'January' then you risk having the following data all being grouped into one bucket which is probably not what you are after.

 

  • January 2015
  • January 2016
  • January 2017

 


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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