Forum Discussion
Selecting Date basis date selected from Slicer
Hi pawan78
1. To create a dynamic date value filter you must create a calendar table which has the relevant dates to be filtered.
With this dynamic approach creating a static calculated column wouldn't be ideal.
2. Create measures similar to the below thread which will give you a dynamic due sales sum for different selections.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!pawan78
Thanks a lot Bijen
This is helpful , also the issue is that i need to create a chart basis the data (# Deals basis Due / Overdue date) , but if i create a measure , i am unable to create the chart as below. (here Z_Overdue Date is Column)
Can you guide on same as well
Hi pawan78 ,
I think you can use measures in bar charts with Column Date on X Axis and Measure Values on Y Axis.
If you can share the specific issue you face on the chart or a pbix file would be easier to help you better.
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!