Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mohamed Azarudeen]

Hi,

I want to show my data in MM/YY format , Its sorting fine for YY/MM format but it does not
work for MM/YY ,please find below in the screen shot.

Here with attached my sample, Please help me in this, Thanks in Advance.

Thanks and Regards,
Azar

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————

[Ashley Hsia]

?Is your column formatted as text?  You might need to edit your query so the column is a date-type.

Best wishes,

——————————
AHsia
——————————
——————————————-

[Tobias Riley]

Hi, Set the Sort By Column of MM_YY to date

——————————
Toby Riley
The Data Crew (https://thedatacrew.com)
Manchester
——————————
——————————————-

[Lutz Bendlin]

Use the “Sort by another column”  feature with your Month Number column in your Dates table.

——————————
Lutz
——————————
——————————————-

[Dan Edwards]

Mohamed,

I agree with everyone’s comments about using Sort by Column.  The key to this feature is you need another column that matches up 1 to 1 with the column it is sorting.  So looking at your data, make sure you use Sort by Column on the MM_YY column and sort it by the monthofyear column.

——————————
Dan Edwards
Senior Manager
Crowe LLP
Huntington Beach CA
714-231-2202
dan.edwards@crowe.com
——————————
——————————————-

[Ashley Hsia]

?Yes – I found this nice explanation from radacad yesterday.  This doesn’t show a date table, but it is the same principle as Dan and Lutz are discussing.  The key is the lookup table (in this case your Date table) to address the cardinality issue.

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi

Best wishes.

——————————
AHsia
——————————
——————————————-