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.
Question
Change the month data format from 2026-05 to May
Hi
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
Planview Customer Community
Already have an account? Login
Planview Customer Community
No account yet? Create an account
Login with SSO
Login with Planview Adminor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
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
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