Service is missing sort option found in Desktop for Column and Line chart

[hwong]

I have a Column and Line visual where I would like to sort by the Line Values (Lactate Bin %). This works in desktop:

But when I publish the report to the service, the sort order is wrong because sorting by Line values it not even available:

Is there a way to make the service show the same sort options or have the same behavior as Power BI Desktop?

[Burningsuit · Accepted solution]

Hi @hwong 

The November update to Power BI changed the sort facilities, see Power BI November 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI If you update your Power BI Desktop to November you will see those options.

However when you publish to Service you will see that in this case it doesn't allow sorting by line values.

I expect they will update the Service shortly to fix this, but if it is a critical problem you should check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
To see if anyone else has raised the issue and if it is not there, then you could post it.
Alternatively if you have Pro account you could open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

Hope this helps

Stuart

[hwong]

Thanks, I found the issue already submitted to the Issues forum here and upvoted it: https://community.powerbi.com/t5/Issues/Line-and-Stacked-Column-Chart-Missing-Sorting/idc-p/2195003#...

I also submitted a support ticket with Microsoft.