Calendar Table displays different in Power Bi than it does in Power Query

[lkaneff]

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?

[ppm1 · Accepted solution]

In the Data View, right click on your first column and choose Sort Ascending. In DAX, the row order doesn't matter. Usually it displays as expected, but it is not a big deal if it doesn't.

Pat

[lkaneff · Accepted solution]

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. 

[ppm1 · Accepted solution]

In the Data View, right click on your first column and choose Sort Ascending. In DAX, the row order doesn't matter. Usually it displays as expected, but it is not a big deal if it doesn't.

Pat