Date spacing in graphs

[Anonymous]

Hi All,

My company uses a generic date field that lists like Friday, March 20, 2020.  When I put this into a graph based off monthly data it spaces is out very nicely by listing every 3rd month or so.  Like below:

When it comes to daily data though it throws in every date making the graph unreadable.  So, I created a Month Year date column.  I used a simple format to pull Month as 'MMM' and Year out of the date field.  When I throw that into the graph lumping the daily data together it shows every single month like so:

My simple question is this: is there any way to space it out or tell the graph to not list every date?  I'd like it to mirror or act like the first example as its a page of graphs and they all look like the first except for the last one which looks above.  Then it looks out of place obviously.  Is it possible? When looking through the fields in the graph for the axis it doesn't appear so.  Any thoughts?

Thanks!

[v-lionel-msft]

Hi @Anonymous ,

Your "Month Year" column should be a text data type, and you cannot make changes to its display, so you should use a date type column. Maybe you can set as below:

Or use the date hierarchy feature?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

You're right - I did have my column set to Text - forgot to categorize it after I created it.  I changed it to a Date and it works as the others do now.  Thanks for pointing me in the right direction.

[Greg_Deckler]

Are you using a continuous or categorical x-axis?