I'd like to filter the last 2 years based on selected year and month slicer.
For example: if I select May - 2023, then I should get data from January 2021 - May 2023.
if I select April - 2024, then I should get data from January 2022 - April 2024
How can this be achieved?
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.