How to add Label

Question

How to add Label

Alan Chen 60

Could anyone help how to add "Year" label" under the Month

User's image

Best Regards,

Alan

Accepted answer

1 additional answer

Your answer

Answer 1

Syed Saleem Peera 11,870 Microsoft External Staff

Hi Alan Chen,

Thank you for reaching out to us on Microsoft Q&A forum.

To display the "Year" label under the Month in Power BI, you can enable the Date Hierarchy by selecting the Date field in the X-axis, clicking the dropdown next to it, and choosing "Date Hierarchy." Ensure both Year and Month are included, then use the Drill Down (⏷) button in the visual to display them together. Kindly refer the below screenshot.

User's image Alternatively, if you prefer a single field that combines Month and Year, you can create a new column using DAX with the formula: Month-Year = FORMAT('Date'[Date], "MMM YYYY") This will format the date as "Jan 2025" and can be used on the X-axis instead. Kindly refer the below screenshot.

User's image

If you are still facing any issue, please let us know in the comments and where you are encountering this error along with the screenshot for reference. We are glad to help you.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Thank you.

Alan Chen 60 Reputation points

2025-03-05T16:57:37.5333333+00:00

Hi, thanks your reply.

I created Date Hierarch, however when I drill down to month level, all data will be shown in the chart instead of only 12 months. I just want to show the last 12 months data.

Could you help how I can solve it.
Alan Chen 60 Reputation points

2025-03-05T17:01:32.87+00:00

Hi, thank you your reply.

I created Date Hierarchy, however it shows all data instead of the last 12 months if Year level is added. How I can solve this problem?
Syed Saleem Peera 11,870 Reputation points Microsoft External Staff

2025-03-06T05:38:44.62+00:00

Hello Alan Chen,

Thank you for your patience.

To display only the last 12 months in your chart, apply a Relative Date filter on the Date field, set it to the last 12 months, and click Apply filter. Additionally, avoid using the full Date Hierarchy on the X-axis; instead, use either the Date field or a Year-Month column to ensure accurate filtering.

Please refer to the screenshot below for guidance.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.
Syed Saleem Peera 11,870 Reputation points Microsoft External Staff

2025-03-10T13:05:48.7233333+00:00

Hi Alan Chen,

Glad to hear that your issue got resolved. Please don't hesitate to reach out to us if you have any further queries.

Thank you.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

How to add Label

1 additional answer

Your answer