Forum Discussion
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
Anonymous,
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/
Hi,
I have solved a similar question in the attached files.
Hope this helps.
- Anonymous1 year ago
Fantastic, thanks a lot. The article gave me the solution I needed.
5 Replies
- DataInsights
Super User
Anonymous,
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/
- AnonymousNot applicable
Fantastic, thanks a lot. The article gave me the solution I needed.
- Ashish_Mathur
Super User
Hi,
I have solved a similar question in the attached files.
Hope this helps.
- AnonymousNot applicable
Very good solution, my compliment. I have choosen the one of DataInsights because it suits more my need.
- Ashish_Mathur
Super User
Thank you.