I have a simple tornado chart using ESTIMATE vs PLAN by SALESPERSON (OBCHODNIK) After PBI MAY UPDATE chart does not show SALESPERSON (OBCHODNIK) NAME. INSTEAD of HAMALA it shows NaN/NaN/0/NaN ESTIM...
Rad0mir
9 years agoRegular Visitor
THIS IS FINAL table with 2 columns highlited - SUMA (SUM) and TYP (TYPE)
MEASURES
FORECAST = CALCULATE(sum(FINAL[SUMA]);FILTER(FINAL;FINAL[TYP]="FORECAST"))
ACTUAL = CALCULATE(sum(FINAL[SUMA]);FILTER(FINAL;FINAL[TYP]="ACTUAL"))
If a switch to ACTUAL TORNADO CHART SHOW OBCHODNIK(SALESPERSON), but WITH FORECAST it does not work
thanx
Radomir