Forum Discussion
How to change date format on x-axis?
Hi guys,
I'm new to power Bi and I'm just playing around at the moment.
I've created a line chart to show total invoice values by month and would like the x-axis to be in the format 'December-19' or 'Dec-19'. I clicked on the date column, went into Modeling > Format and changed it to 'MMMM yyyy' however the graph still just shows the months.
Also my dataset runs from November 2018 until October 2019 so how do I change the order of the x-axis becasue the graph goes from October 2019 to November 2018 so ideally I'd like November 2018 and December 2018 to be at the beginning.
Many thanks for your help in advance.
CMMkamil are you showing date hierarchy or date on x-axis, you can check by clicking arrow next to date date column in x-axis section