Forum Discussion
SuddenClarity
Helper I
3 years agoDisplay last six months in visual based on user date selection
Essentially, I am trying to filter the axis of my line chart to only show the six months leading up to any given date based on user selections. In my report I have two slicers for year and month....
- 3 years ago
pls see this video
https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/
Ahmedx
Super User
3 years agopls see this video
https://www.sqlbi.com/articles/show-previous-6-months-of-data-from-single-slicer-selection/
SuddenClarity
Helper I
3 years agoThanks, I followed the video instead and they do go through the solution without Tabular Editor. And it works in my case. Essentially, you would have to create a seperate "last 6 months" measure for each individual measure you want this filter applied on, but thats OK for my purposes.
Thanks again!