Only first and last dates on x-axis

[donaldo]

Hi all,

I have a table with values filtered by a standard date dimension table.

I have a date slicer setup and want to have a visual of sorts showing only the first and last date on the x-axis - instead of a continuous time series inbetween the two.

Is that possible?

[v-kelly-msft]

Hi @donaldo ，

I will show you a workaround:

Create 2 measures as below:

Measure = CALCULATE(MIN('Table'[Date]))

Measure 2 = CALCULATE(MAX('Table'[Date]))

Create a line chart and add date and value in the visual, then turn off the X- axis :

Create 2 card visuals then put 2 measures above in it : category:off

Finally you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!

[donaldo]

Hi @v-kelly-msft 

Thanks for the solution. Sorry for the delay in answering. Covid-19 caused priorities to change - but I'm back now.

It might be the solution I have to go with, but the request is to not have the values in between the two dates. So ideally a bar chart with only 2 points on the X-axis and only 2 correspnding Y-values. If we span enough time the line chart or whatever inbetween will be very long.

There is no way to get it to show just a MIN and a MAX value?

[Greg_Deckler · Accepted solution]

Turn off the axis and perhaps use Card visuals to show first and last dates.