Forum Discussion
Beatify month-year axis inside report
I've created bar chart report showing some trends. I want to disply year and month by x-axis.
I was able to make it work with the following solution:
I'm using calculated column and combining Year + substring(month). It works, but it doesn't look as good as I want.
I want to use for my axis something similar to timeline visual:
Year, then month (say without quater).
Is it possible to do that, or my current solution is the only option?
Hi Anonymous,
Have you tried to use the date hierarchy of date for axis and then on the axis turn off the concatenate should give you something like this
3 Replies
- MFelix
Super User
Hi Anonymous,
Have you tried to use the date hierarchy of date for axis and then on the axis turn off the concatenate should give you something like this
That's absolutely amazing! Thank you very much!
- austinsense
Impactful Individual
This works great in Excel but there's no great way to do it in PBI yet. The way you're doing it now is probably the best way (as far as I know).
