clustered column chart how to display only the actual current months

[MarcoMizz]

Hi Everyone, 

I would like to know if it is possibile to display in the clustered column chart only the current monts of the year, so for example suppore the current month is march 2023 in the chart I would like to see, automatically, only the column bar related to january february and march on X-axis. then in april the column bar will be added automatically.

I hope my request is understandble 🙂

Regards

marco

[MarcoMizz]

Hi Amitchandak 

your DAX formula fuction very well, I just modify a little bit, because I need to have the difference between budget value and actual value, see below the coding

thanks a lot fo the help

marco

Test New measure =

var _max = today()

var _min = eomonth(_max, -1*month(_max) ) +1

return

calculate( (sum(fFLXScritture[Actual]) - SUM('fMBCR_Budget'[BUDGET])), filter('Calendar', 'Calendar'[Date] >=_min && 'Calendar'[Date] <=_max))

[amitchandak · Accepted solution]

@MarcoMizz , if there is no filter on date, this will give YTD trend

new measure =
var _max = today()
var _min = eomonth(_max, -1*month(_max) ) +1
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))