Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Date spacing in graphs

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 o...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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.