Forum Discussion
Help Needed: Creating Custom Date Range Filter in Power BI from Month and Year Selection
Hello Power BI Community,
https://drive.google.com/file/d/1fzfck3WHfn7xLh0OrHTEXg0wpaiDs94S/view?usp=sharing
I'm currently facing challenges in creating a custom date range filter based on user-selected month and year in my dashboard. Here's what I'm aiming to achieve:
Required Outcome:
When a user selects, for example, "Nov" and "2023":
- The dashboard should display data starting from Oct 26th, 2023, to Nov 26th, 2023.
Could someone guide me on the correct approach or provide the necessary calculated field formulas to generate this specific date range based on the user-selected month and year in Power BI? Any insights or alternative approaches would be greatly appreciated!
Thank you in advance for your help and insights!
Best regards,
MANOJ PRABHAKAR
2 Replies
- v-weiyan1-msftCommunity Support
Hi manoj_0911 ,
I can't open your pbix file.
Please provide detailed sample data and the results you are hoping for again. We can better understand the problem and help you. Show it as a screenshot or excel. Please remove any sensitive data in advance.
Best Regards,
Yulia Yan- manoj_0911Kudo Commander