Forum Discussion
Solved
Relating date Slicer with a Calendar Date Line Chart
Hi friends. I have a Calendar Table (CALENDARIO) created with the min and max of 2 columns dates ([Plan Date] and [Real Date]) from another table (HITOS), and I use it for the X axis of a Line Ch...
hi MauroBote
Just the adjust the two measure as below:
PLAN AC =
CALCULATE(
SUM(HITOS[PESO]),
USERELATIONSHIP(CALENDARIO[Date],HITOS[FECHA PLAN]),FILTER(
ALLSELECTED(CALENDARIO[Date]),MAX(CALENDARIO[Date])<=MAX(HITOS[FECHA PLAN])&&
ISONORAFTER(CALENDARIO[Date], MAX(CALENDARIO[Date]), DESC)
)
)/HITOS[Total % PESO]REAL AC =IF(max(CALENDARIO[Date])>today(),"",CALCULATE(SUM(HITOS[AVANCE REAL]),USERELATIONSHIP(CALENDARIO[Date],HITOS[FECHA REAL 2]),HITOS[FECHA REAL 2]<>BLANK(),FILTER(ALLSELECTED(CALENDARIO[Date]),ISONORAFTER(CALENDARIO[Date], MAX(CALENDARIO[Date]), DESC)))/HITOS[Total % PESO])Result:
Regards,
Lin
hi MauroBote
Just the adjust the two measure as below:
PLAN AC =
CALCULATE(
SUM(HITOS[PESO]),
USERELATIONSHIP(CALENDARIO[Date],HITOS[FECHA PLAN]),FILTER(
ALLSELECTED(CALENDARIO[Date]),MAX(CALENDARIO[Date])<=MAX(HITOS[FECHA PLAN])&&
ISONORAFTER(CALENDARIO[Date], MAX(CALENDARIO[Date]), DESC)
)
)/HITOS[Total % PESO]
REAL AC =
IF(max(CALENDARIO[Date])>today(),"",CALCULATE(
SUM(HITOS[AVANCE REAL]),
USERELATIONSHIP(CALENDARIO[Date],HITOS[FECHA REAL 2]),HITOS[FECHA REAL 2]<>BLANK(),FILTER(
ALLSELECTED(CALENDARIO[Date]),
ISONORAFTER(CALENDARIO[Date], MAX(CALENDARIO[Date]), DESC)
)
)/HITOS[Total % PESO])
Result:
Regards,
Lin
Thank you so much Lin. You are a genius!!!