Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
2 years ago

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