Forum Discussion
Solved
Dynamic Dates for 13-Month Trend
Hi - I am attempting to get a dynamic 13-month trend that will update based on the date I select in a drop-down. For example, when I select February 2025, I want the trend to show February 20...
Hi,
I have solved a similar question in the attached PBI file.
abd8,
Verify the columns in the relationship between 'Previous Date' and 'Calendar'. The columns in the relationship should be used in the USERELATIONSHIP function.
Ok, I set up the relationship and that formala is now working. How do I now set up my slicer and x-axis to ensure a proper 13-month lookback on the x-axis based on the slicer selection?
abd8,
The slicer would be based on a 'Calendar' field such as Year Month (you should be able to control all visuals with this slicer). The x-axis would use a 'Previous Date' field.