<div>
You can read about it here (it is a quite common case):<br><a href="https://whitepages.unlimitedviz.com/2020/05/formatting-the-x-axis-in-power-bi-charts-for-date-and-time/" rel="ugc">https://whitepages.unlimitedviz.com/2020/05/formatting-the-x-axis-in-power-bi-charts-for-date-and-time/</a>
</div>


Retired

Liberty4all

<div>
Unfortunately, that example doesn't work for my data. &nbsp;An area chart does a better job of displaying results than the line and clustered chart in the example. &nbsp;I was able to get the Month and Year to appear in the desired order so that is a plus but I'm not able to make it happen consistently. &nbsp;I will continue to work on it. &nbsp;If you can suggest another option I would appreciate it.
</div>


<div>
<div class="content wysiwyg-content fr-view">
I'm trying to create a line graph in Power BI but am not able to get individual dates to appear on the X axis. &nbsp;The Collection Date column in the source table is formatted mm/dd/yyy and currently has values from 7/7/2020 to 5/25/2021 (23 records).&nbsp; &nbsp;Selecting Day from the options in the Axis box result in values of 2M, 4M, and 6M appearing on the X axis which are not meaningful and have no relation to the data. &nbsp;If Month is selected from the options in the Axis box each month of the calendar appears but in chronological order (Jan, Feb, Mar, etc). &nbsp;I can accept month if that is my only choice but it needs to appear in Month Year format and ordered July 2020 through May 2021.<br><br>The source table has a column titled Fiscal YTD Range with a value of "7/1/2020 to 6/30/2021" for each record. &nbsp;It would be nice to have this appear for the user's benefit but I'm not able to add that to any box as the system won't accept it.<br><br>Any suggestions on what I should try would be appreciated.&nbsp;&nbsp;
</div>
</div>



I'm trying to create a line graph in Power BI but am not able to get individual dates to appear on the X axis.  The Collection Date column in the source table is formatted mm/dd/yyy and currently has values from 7/7/2020 to 5/25/2021 (23 records).   Selecting Day from the options in the Axis box result in values of 2M, 4M, and 6M appearing on the X axis which are not meaningful and have no relation to the data.  If Month is selected from the options in the Axis box each month of the calendar appears but in chronological order (Jan, Feb, Mar, etc).  I can accept month if that is my only choice but it needs to appear in Month Year format and ordered July 2020 through May 2021.
The source table has a column titled Fiscal YTD Range with a value of "7/1/2020 to 6/30/2021" for each record.  It would be nice to have this appear for the user's benefit but I'm not able to add that to any box as the system won't accept it.
Any suggestions on what I should try would be appreciated.  

Need help getting dates to appear on X axis in Power BI

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, and is easily embedded in websites and apps. Power BI offers live dashboards and visual reports to help “bring your data to life.” There are many opportunities for customization, as well as built-in options for your visualizations and analytics. With the Power BI mobile app, you can receive push notifications about important data changes, allowing you to react and plan right away.

Power BI

A desktop computer is a personal computer designed for use at a single location due to its size and power requirements, usually by one person. The most common configuration has a case that houses the power supply, motherboard, disk storage (usually one or more hard disk drives and optical disc drives); a keyboard and mouse for input; and computer monitor and printer for output. The case may be oriented horizontally and placed atop a desk or vertically and placed underneath or beside a desk.