Skip to main content
Question

Change the month data format from 2026-05 to May

  • May 31, 2026
  • 1 reply
  • 43 views

I create a stacked chart in a report using the Created on Data field.  It shows as 2026-05, but I want it to say May in the chart.  I don’t see an option to change the format of this field.

    This topic has been closed for replies.

    1 reply

    Planview Falcons
    Forum|alt.badge.img+1
    • petegush
    • Planview Falcons
    • June 9, 2026

    Hi ​@jsjames 

    You can’t change the dispay format in the chart unfortunately.

    One possible way to get this result would be to use a custom field to return the date as a month label, and then use that in your chart.

    For eg, create a text custom field “Created On Month” and set it as a formula field to returnt he year and month. For example the formula ToString($CreatedOn, 'yyyy MMMM') will return 2026 June where the created on date is 09-06-2026 (I am using an EU date format).

    In the chart below I’ve stacked based on the custom field, against the project status.

    Without seeing the chart and having a clear picture of what you’re trying to acheive I can’t be certain that this will meet your requirement here, so you may want to work with your PS consultant to find the right approach for you.

    Let me know how you get on!

    Pete

     

      Terms of UseAccessibility statement
      All Data Subject Access Requests (DSARs), and requests of “Do Not Sell My Personal Information” according to the CCPA, must be submitted through the Planview DSAR portal located here

      Planview has appointed a Data Privacy Officer (DPO) to be responsible for overseeing our Privacy Management Program and related privacy compliance measures. DPO can be contacted at privacy@planview.com