how to show current year sales in months in bar chart

[Akina0929]

HI Friends,

         I would like to show year wise sales in bar chart but current year sales in months like below attached image.so please help me to Achieve this

[#2]

use this expression in you dimension in you chart.

sort by number

=if(ano<Year(Today()),ano,Date(MakeDate(ano,mes,1),'MMM-YYYY'))

you can too make sam calendar in script

[pooja_sn]

Add below expression as Dimension:

= if(match(Year(Date),year(Today())),MonthName(Date),Year(Date))