Forum Discussion
Solved
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:)
Try to create like below
MonthYear = FORMAT([Date], "yyyy-MM")