cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbhwcm Frequent Visitor
Frequent Visitor

Formatting Date Hierarchy

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?

 

 Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Formatting Date Hierarchy

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Community Support Team
Community Support Team

Re: Formatting Date Hierarchy

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.