How to get last and first selection of Date slicer in X axis of chart or in columns of matrix

[SoufTC]

Hello Everyone,

I try to make a chart of a classic sum and I have for the X axis Date but this date I try to have only the last date and the first date chosen in the filter date slicer.

Now I get this result :

but what I want to have as a result a chart whith juste in X axis 2020-01-01 and 2021-03-31 ! of course I don't want to use a multiple choice drop down filter

I don't know if it's possible for a chart or for a column matrix ! thank you in advance for your help ^^

Bof,

[Anonymous · Accepted solution]

Hi @SoufTC ,

You can add a visual level filter.

First you need to create a measure.

Measure = var _max=MAXX(ALLSELECTED('Table'),[Date])
var _min=MINX(ALLSELECTED('Table'),[Date])
return 
IF(_max=MAX('Table'[Date])||_min=MAX('Table'[Date]),1)

This is the stacked column chart with no visual level filter added.

When you add a visual level filter.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.