Forum Discussion
Month Sorting Issue in Fabric Semantic Model (Direct Lake) – Jan/Feb/Mar sorting in PBI desktop
Hi TGKiruba
Based on your description and the screenshot, this is an expected limitation of certain auto-generated Direct Lake semantic models rather than an issue with your calendar table.
- In Direct Lake semantic models created automatically from a Lakehouse, some model metadata properties (including Sort by column) are read-only unless the semantic model supports metadata editing. When metadata editing isn't available, the Sort by column property appears disabled (greyed out), preventing you from assigning MonthNameShort to sort by MonthDisplaySorted.
- .Why this happens
i) Your semantic model was auto-generated from a Lakehouse.
ii)Metadata editing is not enabled/supported for this model. As a result, model properties such as Sort by column cannot be modified in the Fabric web modeling experience.
Useful Links : Learn about editing semantic models in Direct Lake storage mode in the web - Microsoft Fabric | Microsoft Learn
Solved: Re: Sort column in table by another column when ta... - Microsoft Fabric CommunityHope this helps !!
Thank You.
“Thanks for the suggestion.
In my Direct Lake semantic model, Sort By Column is greyed out in the Fabric web modeling view.
The model dim calendar is auto‑generated from a Lakehouse (notebook), and metadata editing is not enabled.
Because of this, I cannot set Sort By Column on MonthNameShort or MonthDisplaySorted.
Is there any workaround for auto‑generated Direct Lake semantic models where Sort By Column is disabled?”
Hi TGKiruba
Based on your description and the screenshot, this is an expected limitation of certain auto-generated Direct Lake semantic models rather than an issue with your calendar table.
- In Direct Lake semantic models created automatically from a Lakehouse, some model metadata properties (including Sort by column) are read-only unless the semantic model supports metadata editing. When metadata editing isn't available, the Sort by column property appears disabled (greyed out), preventing you from assigning MonthNameShort to sort by MonthDisplaySorted.
- .Why this happens
i) Your semantic model was auto-generated from a Lakehouse.
ii)Metadata editing is not enabled/supported for this model. As a result, model properties such as Sort by column cannot be modified in the Fabric web modeling experience.
Useful Links : Learn about editing semantic models in Direct Lake storage mode in the web - Microsoft Fabric | Microsoft Learn
Solved: Re: Sort column in table by another column when ta... - Microsoft Fabric Community
Hope this helps !!
Thank You.
Hi TGKiruba
Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.Thank You! respone is super useful!