Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Chart data contains not a number (NaN) values

Hello there,   I hope that somebody can help me. I have the dreaded “Chart data contains not a number (NaN) values.”, message and I don’t think that I am dividing by Zero. Here is my DAX Code:   ...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Could you please check whether all your columns are in number format? Kindly share your pbix to me to have a check if possbile.

 

Regards,

Frank

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

Has your issue been solved? If any other question, feel free to let me know please.

 

Regards,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-frfei-msft,

     

    Thank  you for your reply. I wasn't able to fix this issue yet. 

     

    From the above DAX code I looked at each column and found the following data:

     

    [GCAS_Code] = Only Numbers (e.g. 82845734)
    [Inventory_Date] = Only Numbers (e.g 12/6/2018)
    * [Cases_Inv] = Contains '0' or 'NaN' values
    [BUOM] = Contains (Blank) or 'CS' text values
    [ItemPerCase] = Contains (Blank) or Number values
    [SU_Factor]  = Contaions Number values
    [Inventory Qty]  = Contains Number values

     

    The Cases_Inv Column acutally has 'Nan' writen in it, which might be causing the problem.

    Thje Cases_Inv is a calcualted column and the DAX is as follows:

     

    Cases_Inv = if([BUoM]="CS",[Inventory_Qty],[Inventory_Qty]/[ItemPerCase])

     

    Do you think I could change anything in the above, so I don't get the 'NaN' result?