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

Inconsistent sorting issues from excel source data

Capture.PNG

 

I am using 2 columns in excel formatted as dates to generate two separate bar charts in power BI. One column shows in fields as broken down into date, month, year and so allows me to sort and manipulate the data (see picture. However the other column does not have it's date separated in the fields (missing Month and Year) so I can't sort it properly.

 

I thought it may be because one column was sourced using a vlookup but I changed this to the same date format as the other one(copied and pasted as text, then coverted to date) and I'm still having the same issue.

 

Stuck on this so would appreciate any help.

 

2 REPLIES 2
jthomson New Contributor
New Contributor

Re: Inconsistent sorting issues from excel source data

What data type are these showing as in Power BI? Are they both dates or is one formatted as text?

jb19 Frequent Visitor
Frequent Visitor

Re: Inconsistent sorting issues from excel source data

Hi thanks for replying. How do I check this? I'm new to Power BI and am using the web version.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 136 members 1,461 guests
Please welcome our newest community members: