Forum Discussion
Re-arranging Column Headers (Dates) in Matrix Visual
Check your column type and see if it is date. If not, change it to date then Power BI should be able to sort the column accordingly.
Hi All,
Apologies this is probably a stupid question but I'm very new to Power BI. I did have a quick search of the forums to no luck (Only a solution if you had a table with the columns in which you could reverse index?)
I have a matrix visual which displays a monthly breakdown however they aren't in the correct order. E.g. the table columns are currently as follows:
April 2018 | December 2017 | February 2018 | January 2018 | March 2018
Obviously I want them to be sorted with the oldest first. Is there an easy way to do this that I'm missing?
Any help is greatly appreciated.
Thanks.
Check your column type and see if it is date. If not, change it to date then Power BI should be able to sort the column accordingly.
Perfect, thankyou! Knew there'd be an easy fix I was missing.