Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |