Sorting Issue in Time Dimension

[Anonymous]

Hi All,

I created calculated table to have a time dimension.

But when i select Month in slicer then it is not sorting in a proper way. 2019 April comes first before to the 2019 February.

Also while creating calculated table i couldn't able to find calendar icon in prefix of C_Sales_Date same as Sales Date in "Table" Table.

 I know how to sort in normal scenarios but not sure on what to do in calculated tables especially in time dimension.

Any help will be very greatful.

Thanks in Advance.

[Mariusz · Accepted solution]

Hi @Anonymous 

You need a sort by column

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.