Data with Zero values

[bvsaicharitha]

HI

When I loaded an large excel file in power BI, the data with the numeric values are displayed as 0s but when I checked in edit queries, I could see the actual numeric values.

I am not able to create a new column with those columns( For example when I divide two columns it is taking 0/0 and displaying NaN)

Can you please help me why it is happening like that and how to rectify it?

[Greg_Deckler]

In the Modeling, perhaps increase the number of decimals for that column?

[bvsaicharitha]

Thanks,In ModellingIn Query editorIn Query Editor

I could not still able to see the values after increasing the decimal 

[bvsaicharitha]

Pbx file? How can I send you? I do not see that option

[v-jiascu-msft]

Yes, the pbix file. You can upload it to the cloud drive like OneDrive, GoogleDrive then share the download link here. You'd better attach the source file. Or we can't see the data in the Query Editor. Please mark or delete the private data first.

Best Regards,

Dale

[bvsaicharitha]

https://drive.google.com/file/d/1CR1FCjoqSI0cZ6d_3QV9zoTZ1MKLbAEW/view?usp=sharing   - Pbx file

https://drive.google.com/file/d/10c3f052QlTbFOdHilTuNzLj1OogKuCuO/view?usp=sharing      - data source

[v-jiascu-msft · Accepted solution]

Hi @bvsaicharitha,

Actually, you have 0s in the data source. So there may not be any issues. You can filter out these 0s in the Query editor or handle them in the DAX formula. For example, 

Measure = DIVIDE(3, 0, 99)

Column =
IF ( ISBLANK ( [Column1] ) = TRUE () || [Column1] = 0, 0, 3 / [Column1] )

Best Regards,

Dale

[v-jiascu-msft]

Hi @bvsaicharitha,

Can you share the file? You can delete other parts first. It's hard to troubleshoot through snapshots.

Best Regards,

Dale