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?

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

Only first and last dates on x-axis | Microsoft Fabric Community

Greg_Deckler
Community Champion
6 years ago
Turn off the axis and perhaps use Card visuals to show first and last dates.
v-kelly-msft
Community Support
6 years ago
Hi Anonymous ，

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!
- Anonymous
  Not applicable
  6 years ago
  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?