cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Community Support

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")``

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.

2 REPLIES 2
Frequent Visitor

Hi @v-jingzhang

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

Community Support

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")``

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.

Announcements

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors