Forum Discussion
Solved
Sorting Column Dates in a Matrix Table
Hi All, I am hoping to get some assistance using the Power BI Service. I would like to create a matrix table that shows sales figures by month for a list of subsidiaries. I can create the matri...
I've managed to solve this by editing the Semantic Model, selecting my Date table -> Month_Name field and then in the Advanced Settings there was an option to select a sort by column.
This then sorted the columns in the Chronological order.
Hopefully this helps someone in future.
I've managed to solve this by editing the Semantic Model, selecting my Date table -> Month_Name field and then in the Advanced Settings there was an option to select a sort by column.
This then sorted the columns in the Chronological order.
Hopefully this helps someone in future.