Forum Discussion
PowerBI not taking decimal values
Hi, When I am adding decimal values in data source(MS excel) power bi not takinhg it as it is(0.4,0.5,0.6 etc..) giving only 0.
Make sure that you have an explicit query step that sets the data type to decimal. Format in the report is not enough. Even if the column looks like a decimal in the query editor, that is not enough. You need to put in a step that actually sets the column's data type to decimal. This has to be done in the query editor.
Thank you so much! Was messing around with it for 30 minutes before I came across your response.