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 agoI'm not sure if I understand this solution. They wrote that, "We implemented this logic in a calculation group named Previous Period with a calculation item that filters the last 6 months"
Does that mean I need to use calcualtion groups for this solution to work? I don't really have much experience with Tabular editor as my company does not allow it. Do you know if this solution can be reformatted to work with just PBI desktop?