Forum Discussion
Month/Year under chart/graph
I am trying to figure out how to ge the year to only appear once under the months for that specific year, like in the image below. Has anyone been able to do this in PowerBI? This image is from Excel.
Hi, either if your Year and Month are in Hierarchy or not in Hierarchy, you can all have them show without Year repeating itself simply by placing them on X-axis.
If Year and Month are in Hierarchy and when you set up, do not Concatenate the labels.
Hope it works:)
5 Replies
Hi WallyWallWal ,
Thank you for reaching out to the Microsoft Community Forum.
Hi MasonMA , Ashish_Mathur , Chanty4u , Thank you for your prompt responses.
Hi WallyWallWal , If MasonMA , Response has resolved your issue. Please accept MasonMA response as "Accept as Solution". And, if you have any further query do let us know.
Regards,
Dinesh
Hi, either if your Year and Month are in Hierarchy or not in Hierarchy, you can all have them show without Year repeating itself simply by placing them on X-axis.
If Year and Month are in Hierarchy and when you set up, do not Concatenate the labels.
Hope it works:)
Thank you MasonMA ! This worked perfectly!
Hi,
This is how it is supposed to appear by default. Drag Year and Month name from the Calendar table to the X-axis.
Try to create like below
MonthYear = FORMAT([Date], "yyyy-MM")
