Matrix Showing Wrong Values After Publishing

[lwmns]

Hi all,

I have a matrix visual that plots values to a calendar. When in Desktop, these values show correctly and everything lines up with what is on the database. After publishing to the Service, the values are completely wrong. Things are being pinned to completely wrong dates. 

Has anyone come across this before? I can't think of a reason for the data to break like this after Publishing.

Thanks

[ibarrau]

Hi. I have seen this before. Dates showing issues with the format. The problem was that the date wasn't using the correct type changed at Power Query. Desktop was using local machine region and everything was ok, but the service was mixing dates like mm-dd-yyyy and dd-mm-yyyy on the same column.

You could try making sure all types are regionally changed, refresh desktop and publish again. 

I hope that helps, that's the only thing I can think about now

[lwmns · Accepted solution]

I managed to fix this issue, in case anyone comes across this in the future. The issue looks to be due to some re-ordering that the Power BI Service does with the data. 

I had a table with events and these came with DateFrom and DateTo fields. I created a second table to fill the dates inbetween, so that I could plot them on a matrix showing a calendar. I had created the second table by duplicating the first (including the index from the initial table), which left my second table without a unique index.

Once I added an index to this second table, the data came through as expected. I can only assume that this was due to some optimisation that the Service was doing, that Desktop wasn't.