Show dates after last data point in visual

[Anonymous]

Hi 

I have a stacked column chart showing my orders on y axis and dates on x axis. The problem is that the x axis ends on the date of the latest order. I'd like to be able to see if there have been a few days without orders so I'd like the x-axis to end on the current date. Any way to do this? I know I can set a fixed date to x-axis start and end but how about setting the end date dynamically to always be the date when the report is viewed.

[Anonymous · Accepted solution]

Hi @Anonymous ,

I would create a data table calculated by calendar(min([orderdate],today()), then make the relationship and choose the column from thta table to the x axis.

Let me know if it worked, if so mark as solution.

BR,

DR