Forum Discussion

AnneC's avatar
AnneC
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Sorting Fields on Graph Disappear After Publication

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.....

 

 

 

  • 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. 

     

3 Replies

  • 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. 

     

  • mshenhav's avatar
    mshenhav
    Icon for Power BI Team rankPower BI Team

    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

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support

    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.