topic Create 180 day filter for axis based on date slicer in DAX Commands and Tips

Create 180 day filter for axis based on date slicer

ashaner — Fri, 25 Sep 2020 20:46:24 GMT

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?

Re: Create 180 day filter for axis based on date slicer

Greg_Deckler — Sat, 26 Sep 2020 00:25:22 GMT

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

Re: Create 180 day filter for axis based on date slicer

ashaner — Thu, 08 Oct 2020 19:50:18 GMT

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