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?
Go to Solution.
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
Proud to be a Datanaut!
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).
That's absolutely amazing! Thank you very much!
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.