Rad0mir's avatar
Rad0mir
Regular Visitor
9 years ago
Status:
Done

MAY update problem with TORNADO CHART

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

Reports

8 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Rad0mir

     

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

     

    Best Regards,
    Herbert

  • Rad0mir's avatar
    Rad0mir
    Regular Visitor
    9 years ago

    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's avatar
    Rad0mir
    Regular Visitor
    9 years ago

    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

Completed Ideas