Forum Discussion
Helper IPower BI presenting 0 data from excel sheet
I am building a dashboard and want to visualise my data. I have imported data from excel spreadsheet although for this one measure my data is presented as 0 (zero) in power bi
in excel this data is presented as 0.43 for example
in the query editor my data is presented and formatted as a decimal number for 2 decimal places.
any ideas would be greatly appreciated
Yes will do, thanks for your help
I had to take the query back to the source, It seems there was an issue when changing the format of a column within the query editor. This changed the value of that column to "0" When trying to change back the values remained as zero or every column format automatically changed to text which was frustrating and still upon format changing again from text to whole or decimal number the value returned "0"
The only way I could get this to work was to go back into the query ediot and remove queries except the source and start again - luckily the visuals and dashboards where already in place so it was not to time comsuming - although a solution any additional help on this would be awesome guys
Calum
