YTD Date dynamic axis Dimension based on selected value

[vstefano]

Good morning,

I have a filter to select a snapshot date. I have a chart which has as horizontal axis the snapshot date.

I want the horizontal axis to show me just the snapshot date that are equal or lower to the one selected.

I have had a look at blog, articles, features etc but this seems to be a particular case.

If I disconnect the filter and the chart than I get all the snapshot dates, also the one that are after the one selected.

If I connect the filter and the chart, I get only the selected snapshot date.

Finally I have tried to embed the selected snapshot date in a measure using SELECTEDVALUE but it is not possible the axis of a chart referring to the filter measure.

Last but not least I can create a dynamic measure that considers all the snapshot date values lower than the selected date, but I cannot use this measure as a category for the chart.

In the example below I want to display all the snapshot dates up to april 24.

Any hint, suggestion would be apreaciated.

Thanks in advance,

Stefano

[DataInsights · Accepted solution]

@vstefano,

One option is to use a Before slicer. If that's not feasible, check out the article below:

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/ 

[Ashish_Mathur · Accepted solution]

Hi,

I have solved a similar question in the attached files.

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

I have solved a similar question in the attached files.

Hope this helps.

[vstefano]

Very good solution, my compliment. I have choosen the one of DataInsights because it suits more my need.

[Ashish_Mathur]

Thank you.

[DataInsights · Accepted solution]

@vstefano,

One option is to use a Before slicer. If that's not feasible, check out the article below:

https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/ 

[vstefano · Accepted solution]

Fantastic, thanks a lot. The article gave me the solution I needed.