Forum Discussion

JD0963's avatar
JD0963
Icon for Helper I rankHelper 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
Icon for Solution Sage rankSolution 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
Icon for Helper I rankHelper 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
    Icon for Solution Sage rankSolution 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
      Icon for Helper I rankHelper 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?

      • jthomson's avatar
        jthomson
        Icon for Solution Sage rankSolution Sage
        8 years ago

        Yeah, quickly googling makes me think that it's not available for your data source unfortunately, it's not something I'm familiar with so I don't know if there's a way to work around things to get the result I suggested (if that's even the cause)