Bar chart calendar on x axis, how to hide year

[bsz412]

Hi, 

On this visual, I should hide the year, and leave only the month. If I just add current year data it works, but I have 2 bars: current year and last year, and if I add only the months to X-axis, visual breaks as it cannot find the previous year data

It looks like this now: 

And I would need the same without showing the years "2021' and "2022".

Is there any simple way to fix that?

thank you!

[amitchandak]

@bsz412 , You create a measure and filter this year's data in case that is objective. If measures are this year vs last year

This year Today =
var _min = eomonth(today(),-1*month(today()))+1
var _max = eomonth(_min,11)
return
CALCULATE([Net], FILTER('Date','Date'[Date] >=_min && 'Date'[Date] <= _max))

last year measure

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

Make sure the first one is used as a filter too (Visual level)

You can also go to the next level using the drill menu. As of now, you have used expand. Use parallel line