troubleshooting Question

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

Avatar of Liberty4all
Liberty4allFlag for United States of America asked on
Power BIDesktops
3 Comments1 Solution6 ViewsLast Modified:
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.  

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros