Forum Discussion

JD0963's avatar
JD0963
Helper I
8 years ago

Chart order changing upon publishing

Hello. Please see the attached.   I am using the November release of PowerBI. When I have the dashboard open on desktop, the line chart looks like the right of the attached image. It is sorted from...
Need Help
jthomson's avatar
jthomson
Solution Sage
8 years ago

This might be an issue whereby upon publishing it's not reflecting the sort option that you've selected, and instead it's sorting by what looks like the text of the column you're shoving into the axis. What happens if you select your derived column and then outside of the actual visual you tell it to sort by your actual date column?

  • JD0963's avatar
    JD0963
    Helper I
    8 years ago

    What do you mean outside of the actual visual?

     

    The data is stored in an SSAS cube - do you mean try sorting it in the cube?

    • jthomson's avatar
      jthomson
      Solution Sage
      8 years ago

      I mean go into the data view in Power BI, you should be able to select what you're putting into the axis, and then on the modelling tab you should have a "sort by column" option

      • JD0963's avatar
        JD0963
        Helper I
        8 years ago

        For some reason I don't have the data view option available.

         

        My data is coming from AS Tabular not sure if that has anything to do with it?