Forum Discussion

anony711's avatar
anony711
Frequent Visitor
3 years ago
Solved

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.

Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

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

    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

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

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

    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.