Forum Discussion

jbhwcm's avatar
jbhwcm
Advocate I
7 years ago
Solved

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 "Q...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

v-danhe-msft's avatar
v-danhe-msft
Microsoft Employee
7 years ago

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