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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.

  • jbowler's avatar
    jbowler
    Regular Visitor
    11 years ago

    Thanks very much

     

    This method enables a month label to display for each month that has a value - something I couldn't control prior. That is important and makes the visualisaiton by itself readable.

     

    It doesn't ensure a uniform axis - null values are still simply omitted from the chart.

     

    But thinking further a uniform axis is not really the right solution anyway, as in theory I'd need to show all 15 date points (months) to ensure charts are uniform.

     

    FormatDate = FORMAT('Table2'[Month],"MMM YY")

     

     

  • jbowler's avatar
    jbowler
    Regular Visitor
    11 years ago

    Sorry - just checking this again...

    When using the formated column: Month = FORMAT('KPI_Account'[MonthNoFormat],"MMM YY")

     

    it removes the choice to select continuous or categorical. And it appears to switch the date to categorical and NOT keep the date in the correct order. (E.g. displaying Jun 14 after Jan 15...)

     

    For now, I'll use my existing numerical date and just pass it as a categorical. At least this date appears to recognise the correct date order

     

    Thanks all

  • 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.