Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
JessieF
Advocate II
Advocate II

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

Hello friends,


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 to Desktop really frustrating. All this time spent to connect data only to be stumped by a sort feature - argh!

 

In Desktop you can select a column in a table (like week of year) and sort that by another column in the same table. That way I can have a chart by week in ascending/descending order. I know how to do this in Desktop with a date table I build in M or using DAX, but with tables sourced from a Lakehouse, I have lost that table sorting flexibility.  This really puts a strain on my build as I have to go redesign how we do our Date table.  Unless, is there a setting I'm missing? 

 

I thought maybe it was because I was on the Service, so I popped over to desktop and connected to OneLake to get this model and the setting to sort the date table is still disabled? 

 

What are others doing to over come this?

JessieF_0-1713460107970.png

 

Thank you!
Jessie

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @JessieF 

 

Yeah, this is currently a work in progress to get parity between the service and the power BI desktop, right? now, unfortunately, that is not available. You can create or vote for the idea here: https://ideas.powerbi.com





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
JessieF
Advocate II
Advocate II

GilbertQ
Super User
Super User

Hi @JessieF 

 

Yeah, this is currently a work in progress to get parity between the service and the power BI desktop, right? now, unfortunately, that is not available. You can create or vote for the idea here: https://ideas.powerbi.com





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors