Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis 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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |