Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
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.
Hi @v-jingzhang
Thank you for your reply- really appreciate. It worked. Thanks again 🙂
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
13 | |
12 | |
12 | |
12 |