Forum Discussion
Using a Table with Multiple Date Fields
- could you clarify what you mean for this first question?
- i'm intending to have a slicer where I select any two dates and all charts will only represent data between those two dates. for example a chart showing volume of projects based on completion date over time would show only between dates A and B in the slicer, and an ajacent chart showing volumn of projects based on initiation date over time would also onnly show between dates A and B.
Oh that - this is easy - just apply solution 1 (by specifying USERELATIONSHIP in measures) and you will get it:
CHART 1 - This Measure: Volume of projects (BY DATE COMPLETED) = Calculate(COUNT(Projects[Id],USERELATIONSHIP(Calendar[Date],Projects[CompletedDate])
CHART 2 - This Measure: Volume of projects (BY DATE INITIATED) = Calculate(COUNT(Projects[Id],USERELATIONSHIP(Calendar[Date],Projects[InitiatedDate])
....
So, to summarize:
1. Create INACTIVE Relationships between Calendar Date and each date column you want to do breakdowns
2. Create MEASURES for each chart you want (by completed date, initiation date etc...)
3. Put respective measures in respective charts
4. Put ONE Slicer with Calendar Date
5. Enjoy....