visualization with day months and years

[Kanat]

Hello,

At this time I creating dashboards for a large company, 

And I looking for visial where i can show some days, months and years of productions. (example in attachment) but in my examle there are 3 visials separately days, month and years, but i need one visuals where i can see days, months, years.

Can you please help me.

[amitchandak · Accepted solution]

@Kanat , You need create a new column like

Switch ( True() ,

[Date] <= today() && [Date] > eomonth(Today(),-1) , Day([Date]) ,

[Date] >= eomonth(today(), -1*month(today()) ) +1 , format([Date], "mmm") ,

year([Date])

)