Beatify month-year axis inside report

[sKaiNet]

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?

[MFelix · Accepted solution]

 Hi @sKaiNet,

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

[sKaiNet]

@MFelix

That's absolutely amazing! Thank you very much!

[austinsense]

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).