Forum Discussion
Matrix Showing Wrong Values After Publishing
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.
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
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.