Forum Discussion

CMMkamil's avatar
CMMkamil
Frequent Visitor
6 years ago
Solved

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

2 Replies

  • 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

    • CMMkamil's avatar
      CMMkamil
      Frequent Visitor

      Hi parry2k 

       

      It was set to Date Hierarchy, changed it to Bill date and now it's perfect. 

       

      Thanks very much.