topic How to filter date in format mmm-yy? in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3456336#M131753 <P>I want date-format mmm-yy, but on my diagramms data is filtered on alphavit (jan-23 is not first month on 2023)<BR />How can I fix it?</P><P><img /></P><P>&nbsp;</P> Mon, 02 Oct 2023 16:24:34 GMT yakovleva_alena 2023-10-02T16:24:34Z How to filter date in format mmm-yy? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3456336#M131753 <P>I want date-format mmm-yy, but on my diagramms data is filtered on alphavit (jan-23 is not first month on 2023)<BR />How can I fix it?</P><P><img /></P><P>&nbsp;</P> Mon, 02 Oct 2023 16:24:34 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3456336#M131753 yakovleva_alena 2023-10-02T16:24:34Z Re: How to filter date in format mmm-yy? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3457126#M131793 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="618703" data-lia-user-login="yakovleva_alena" class="lia-mention lia-mention-user">yakovleva_alena</a>,</P><P>You'd need to have in your calendar table an additional column to sort by. Then you can sort the column you use in the visual by this column.</P><P><img /></P><P><STRONG><FONT size="2">Best Regards, </FONT></STRONG></P><P><STRONG><FONT size="2">Alexander</FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@powerbi-vlog" target="_blank">My YouTube vlog in English</A></FONT></STRONG></P><P><STRONG><FONT size="2"><A href="https://youtube.com/@pbi-vlog" target="_blank">My YouTube vlog in Russian</A></FONT></STRONG></P><P>&nbsp;</P> Tue, 03 Oct 2023 06:50:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3457126#M131793 barritown 2023-10-03T06:50:58Z Re: How to filter date in format mmm-yy? https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3457160#M131796 <P>Thank you very muuuuch, it's working <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Tue, 03 Oct 2023 07:18:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-filter-date-in-format-mmm-yy/m-p/3457160#M131796 yakovleva_alena 2023-10-03T07:18:48Z