Forum Discussion
Anonymous
6 years agoNot applicable
Plot Line Chart from 2 independent date slicer
Hello Power BI community, Hope everyone is safe and doing good. I need help in regards to a chart layout requirement . I have 2 date slicers Slicer_Date1 and Slicer_Date2 I need to show...
- 6 years ago
Hi Anonymous
Two new date tables and measures created as below:
min = CALCULATE ( MIN ( 'Table 2'[Index] ), FILTER ( ALL ( 'Table 2' ), 'Table 2'[Date] >= MIN ( date1[Date] ) && 'Table 2'[Date] <= MAX ( date1[Date] ) ) ) max = CALCULATE ( MAX ( 'Table 2'[Index] ), FILTER ( ALL ( 'Table 2' ), 'Table 2'[Date] >= MIN ( date1[Date] ) && 'Table 2'[Date] <= MAX ( date1[Date] ) ) ) average = CALCULATE ( AVERAGE ( 'Table 2'[Index] ), FILTER ( ALL ( 'Table 2' ), 'Table 2'[Date] >= MIN ( date1[Date] ) && 'Table 2'[Date] <= MAX ( date1[Date] ) ) ) countall = COUNT ( 'Table 2'[id] )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
6 years agoNot applicable
Thanks v-juanli-msft for the updates.
Can you forward the .PBIX file so that I can give it a shot at my end. Need to validate the Date slicer mapping with mine.
Anonymous
6 years agoNot applicable
Hi v-juanli-msft ,
Just a quick followup on this. Can you please upload the .PBIX file as well.
Thanks
Rohan