Forum Discussion
Create a date variable by using slicers
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.
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/
2 Replies
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/