Forum Discussion

Alaahady's avatar
Alaahady
Helper II
1 year ago
Solved

Sort column in table by another column when table is from Lakehouse

I'm building a report from a semantic model sourced with tables in a lakehouse.  To be honest, I'm finding the lack of data modeling, filtering, sorting tools in the Service for modeling as compared ...
one lake
  • Alaahady's avatar
    Alaahady
    1 year ago

    Thanks to everyone who offered their help. burakkaragoz suparnababu8 WaelGouader 

    I discovered a new option in OneLake via Power BI Desktop. By switching to Edit in Desktop, selecting the relevant column, and expanding the "Advanced" section, you’ll find the "Sort by column" feature. This allows you to sort your Month-Year column using another column (like yyyy-mm) to ensure proper chronological order in your visuals.

     

     

     

WaelGouader's avatar
WaelGouader
Frequent Visitor
1 year ago

Hi Alaahady,

You’re right that sorting a column by another column in Lakehouse-sourced semantic models is currently limited in the Service compared to Desktop.

At the moment:

  • The “Sort by Column” option is not exposed in the Service UI for Lakehouse tables or direct Lakehouse semantic models.

  • You need to set the sort relationship before publishing:

    • Either in Power BI Desktop while building your semantic model,

    • Or by using a Date table with a sort column already aligned in your Lakehouse table.

If you need to sort “Week of Year” correctly:
✅ In your Lakehouse, add a column like WeekSort (e.g., Year * 100 + WeekOfYear) that ensures correct chronological sort order.
✅ When creating your semantic model (or if using Desktop to build it before publishing), use “Sort by Column” there before publishing to the Service.

Unfortunately, there is no toggle in the Fabric Service alone to set “Sort by Column” after the model is published from Lakehouse, and yes, this is a known gap many are waiting to be improved.

Thank You