MAY update problem with TORNADO CHART

[Rad0mir]

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

ESTIMATE is calculated measure

ESTIMATE = [ACTUAL]+[FORECAST]

ACTUAL = CALCULATE(sum(FINAL[SUMA]);FILTER(FINAL;FINAL[TYP]="ACTUAL"))

FORECAST = CALCULATE(sum(FINAL[SUMA]);FILTER(FINAL;FINAL[TYP]="FORECAST"))

MAYAPRIL

[v-haibl-msft]

@Rad0mir

Could you please give some sample data of your table or provide your PBIX file to me?

Best Regards,
Herbert

[Rad0mir]

[Rad0mir]

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

[Rad0mir]

[Rad0mir]

Hallo,

I have found bug in our DATA MODEL.

Column OBCHODNIK contained also null values(not a problem) but (blank) values (caused problem in FORECAST)

I have replaced blank and null values and everything is OK now.

Sorry.

Radomir

[Rad0mir]

ISSUE SOLVED!!!