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
Icon for Community Support rankCommunity 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.