Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

YTD Date dynamic axis Dimension based on selected value

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

 

5 Replies