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")