Sorting by short Month possible?
Hi all I am facing the problem, that there is no way (Or I do not Know) to sort the short Month in the correct timeline order within a PowerBI Report (Jan, Feb, Mar,...). I have a Column representing Year-Month with format 'yyyy-MM', a second one with the short Month name format 'MMM' and a third one with the numeric values. The columns are in a Materialized view of a Semantic Model in Microsoft Fabric. In the Report I see the alphabetical sorting using the Short Month column, which is logical to me. When Using the Year-Month column it is in the correct timeline sorting. All I want is showing the Short Month column in the correct timeline sorting. Using PowerBI and a local Data-Model I am able to change the Sorting within the column Options. But with the Semantic Model created in MS Fabric this option is not available. Even non sorting could help as the data of the Materialized View is in correct sorting. Any solutions on this? Thanks a lot for your Help