Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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/
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/
Thank you so much, this is brilliant!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |