Forum Discussion
Matrix Column Order reseting
Hi all,
I have the below matrix functioning perfectly in PBI desktop but not in PBI web. The order of my column is suddenly changing even though i've sorted it to a Date column which is linked to my date table. Shouldn't this now default to Date order?
Table in DesktopTable on AppSorted Column
Although the issue has vanished for the moment, so maybe it was an old version that hadn't be published over.
7 Replies
I should add, when i initially publish the report, it shows in the correct order. You come back later then it reverts to a seemingly random order
Pleas ensure consistent data from Date column - (replace this data 'Jan - 25 Final' in Date column with 31/01/2025).
Can you please sorting it based on 'Date column' or create a new column named Month_Name and sort 'Date column' by Month_Name
Date column is text, date only column is date value, "Jan - 25 Final" is how we want the final forecast of the month phrased.
Since you are mixing text and dates in your original layout this is expected behavior. To prevent that, use only text columns in your original layout (ie create a reference table) and create a sort column that the display column can be anchored to.
