Create 180 day filter for axis based on date slicer

[ashaner]

Hello,

I have a report setup with a date slicer. The date slicer selects the effective date the user wants to view data for. I also have a line chart to shows "balance" of the accounts for the 180 days before the date selected in the slicer. Is there a way to create a relative date filter based on the date selected in the slicer?

[Greg_Deckler · Accepted solution]

@ashaner Well, you could use a relative data slicer. Otherwise, you would need something like the Complex Selector: 

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

[ashaner]

The complex selector worked for me with a few tweak. Thank you for your assistance!