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.

     

     

     

Alaahady's avatar
Alaahady
Helper II
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.

 

 

 

v-veshwara-msft's avatar
v-veshwara-msft
Community Support
1 year ago

Hi Alaahady ,

Thanks for the update and good to know that switching to Model view allows you to use the Sort by Column option. Appreciate you sharing it here, as it will definitely help others facing similar scenarios.

 

If possible, please mark your response as the Accepted Solution so others can find it more easily.

Please continue using the Fabric Community for any further queries.

Thank you.