Calendar Table displays different in Power Bi than it does in Power Query
I Built a Calendar Table in Power Query and I loaded it to Power Bi. The Date Column in my Calendar table in Power Query Edit mode looks fine. All the dates are in the order that I want them in. However, the loaded table in Power Bi which is the table that shows up by clicking the Data Icon is a mess. My Calendar Date Column shows all the Weekday dates and then lists the weekend dates. Why is this happening?
I sorted by column yymm in my calendar table but now when I drag days to my matrix table the days are in alphabetical order. Sorry i'm just learning DAX and Power Bi. I appreciate the patience of this community for the new people.