Forum Discussion
Solved
How to create Filed parameter with Date selection
Hi Folks, I am new to power BI and got stuck with a requirement. I have to create a customer service report which displays sum of interaction type(call,Email or Chat) and shows barchart and tabular...
Hi abhishek20_09,
Thank you for providing detailed information on your issue. I’ve reviewed your scenario and successfully replicated it using sample data on my end.
I’m sharing the working .pbix file below so you can explore the setup and DAX logic more clearly. Please feel free to open it and review how the relationships and measures are configured:
I hope this helps resolve your issue. If you have any questions or need further clarification, I’m happy to help.
Thank you.
You can also make the dynamic date selection using field parameters for example L1M TO LAST N MONTHS means a drop-down will be provided to the user to select the n months if he selects 6 then L6M data will be filtered