Default the current month & year

[sraj]

Hi there,

Is it possible to default the current month and year on the BAR graph without making any selections on the slicer? One gentleman did help build two columns but I dont know how to use it on my bar graph...Please advise

Column 1

Month Type = Switch( True(),

eomonth([Date],0) = eomonth(Today(),-1),"Last Month" ,

eomonth([Date],0)= eomonth(Today(),0),"This Month" ,

Format([Date],"MMM-YYYY")

)

Column 2

Month Year Sort = Format([Date],"YYYYMM")

[amitchandak · Accepted solution]

@sraj , Please find the attached file after signature, Check Date table and Month Type Page. I do not have latest data. So once you choose this month there will no data.