Sorting Fields on Graph Disappear After Publication

[AnneC]

We have been running an app on Power BI for a while now and our front end charts are sorted by a specific field in order to create a progressive purple line across the chart as follows:

With the three dots on the top right corner, this data was sorted by one of the fields used in this graph, which is a line value and not an axis. Prior to publication all the options of the data to sort the graph by are available, ie:

However, on the latest version of Power BI, after publication all the sort options disappear, and only the options are limited to the two axis, ie:

And as you can see, it totally messes up the graph.  How do I get all the sort options to reappear after publication?  Any help would be greatly appreciated.  Please note that I am an intermediate level user and not familiar with coding, so please keep the advice fairly simple if possible 🙂 Thanks.....

[AnneC · Accepted solution]

Thanks for your responses, I did find a workaround by adding the field to the tooltips and it was then available for the sort options, so my graphic is working again. 

[v-jingzhang]

Hi @AnneC 

This issue has been admitted as an Known Issue in PBI Service. Its ETA for fix is 12/5/2021 and there is no workaround currently. Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[mshenhav]

Hey @AnneC ,

It seems that you have an issue with Power BI Desktop and not Power BI Mobile apps. Can you please post your question in Power BI Desktop forum: Desktop - Microsoft Power BI Community? There is greater chance to get the right people looking at it there...

Thanks Maya