Forum Discussion

jbowler's avatar
jbowler
Regular Visitor
11 years ago
Solved

Dates: change Start & End on axis

Can someone help explain how to use dates with the Start & End? Scoured help files and community but cannot find a mention   I have a date field in my x axis (continous) visualisation. i want to sp...
  • Greg_Deckler's avatar
    Greg_Deckler
    11 years ago

    You could create a calculated field like =FORMAT([date],"mm") or =FORMAT([data],"mmyyyy". Add this as a filter to your visualization and select the same items for each visualization and now your x-axis should be uniform across your visualizations because you are filtering to the same months or month/years.

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Greg_Decklerkonstantinos

is it possible somehow to change the start - end without creating new columns?(live connection)

 

my x axis is monthes over year and it will grow and grow every month

thanks!!

curtisp's avatar
curtisp
Icon for Helper II rankHelper II
10 years ago

I wanted to show just records in report chart for past 30 days..  

 

So I created Custom Column:

 

if Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow()) - [date])) < 31 then "30days" else ">30days"

 

I used this Custom Column as filter in report just to show "30days". This flag updates dynamically with each data refresh so report chart always shows past 30 days data.