Chart order changing upon publishing

[JD0963]

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 the last few weeks onwards, with the latest week being on the right. The axis is a derived column which is the first day name and date of the week.

I have sorted the chart by adding a date tooltip, selecting latest date and then ordering my chart by this (as soon in the right of the photo)

This works fine until I publish it. Once it has been published the order changes from the current week being on the right, to the current week being on the left. (see left chart on attached image)

Is there any reason this is happening or does anyone know a better way for me to achieve this?

Thanks

[jthomson]

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]

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]

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]

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]

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)