Forum Discussion
How create one slicer for two different date type?
Hello
I have two date field: "Date", "Closed Date".
I want create measure for calculte by "Closed Date" and other measure calculate by "Date", but use one slicer with date range. Both measure should set to one vizualization.
Seems set static value for date range in measure isn't true solution.
3 Replies
- amitchandak
Super User
Anonymous , Join both date with Date of date table and use the Date of date table from the slicer.
One join will active. You have to activate other in a measure using use relation
example
v-zhenbw-msftCommunity Support
Hi Anonymous ,
Do Date and Close Date belong to one table or two tables?
One slicer only contains one date range. If you want your Measure to change according to the selected Date, you'd better create two Slicers.
Could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?
It will be helpful if you can show us the exact expected result based on the tables.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
