Create a date variable by using slicers

[Anonymous]

Hi,

I'm relatively fresh to PowerBI and wanted some help with a problem I'm trying to solve. Any pointer is more than welcome.

In my data schema, I have a Date Table that I want to use in one (or multiple slicers) to create dynamic filters that I can apply to the report.

In particular, I want to be able to select in a slicer multiple time periods to slice my data in a "Pre" and "Post" period. Imagine I want to compare Sales from 1/1/23 to 15/1/23 as a Pre-Period and from 15/2/23 to 19/5/23 as a Post Period, by allowing the report user to self select custom periods.

Is that possible?
Thanks in advance.

[vicky_ · Accepted solution]

The trick is actually to have 2 date slicers. Check out this article for a more detailed guide: https://www.phdata.io/blog/how-to-compare-a-value-using-multiple-date-ranges-in-power-bi/

[Anonymous]

Thank you so much, this is brilliant!