Formatting Date Hierarchy

[jbhwcm]

I am tyring to change formatting for the way the quarters are presented in the date hierarchy for a matrix i created.  As shown below, the default shows "Qtr 1", is there any way to get it to show "Q1" instead?

Also, can you change the Total column to say the year?

 

[v-danhe-msft · Accepted solution]

Hi @jbhwcm,

Based on my research, I am afraid you could not change the format of the date hierarchy, I suggest you to create custome data hierarchy. You could refer to below link to create multiple date columns,  and you can achieve hierarchy function by adding multiple columns(Year, Month)  to the "Axis" of a bar or column chart. This way, the chart will also enable you to dill down the data.

Reference:https://kohera.be/blog/power-bi/how-to-create-a-date-table-in-power-bi-in-2-simple-steps/

Regards,

Daniel He