Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
anony711
Frequent Visitor

Change x axis label name - Month/Year

Hello everyone,

 

How would I change/customise the x-axis label e.g.

 

Oct 2021- Sept 2022

Nov 2021- Oct 2022

 

I dont believe grouping works here as I tried doing it and it works only for Oct 2021- Sept 2022 but no option is left for Nov 2021- Oct 2022?

 

Thank you.

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @anony711

 

This looks like getting the 12 month running total for every month, right? Assume you have a Date column, you can add a column to have those labels based on the Date column. For example, 

Period = FORMAT(EOMONTH([Date],-12)+1,"mmm yyyy") & " - " & FORMAT([Date],"mmm yyyy")

vjingzhang_0-1669688650896.png

Sort this new column by "YearMonthNumber" column, then use it on the X-axis. Create a measure to calculate the value you want to put on Y axis. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

View solution in original post

2 REPLIES 2
anony711
Frequent Visitor

Hi @v-jingzhang 

Thank you for your reply- really appreciate. It worked. Thanks again 🙂

v-jingzhang
Community Support
Community Support

Hi @anony711

 

This looks like getting the 12 month running total for every month, right? Assume you have a Date column, you can add a column to have those labels based on the Date column. For example, 

Period = FORMAT(EOMONTH([Date],-12)+1,"mmm yyyy") & " - " & FORMAT([Date],"mmm yyyy")

vjingzhang_0-1669688650896.png

Sort this new column by "YearMonthNumber" column, then use it on the X-axis. Create a measure to calculate the value you want to put on Y axis. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors