- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Rangapbi
Go into the Query Editor and make sure that for your column the dataset is changed to either Decimal Number or Fixed Decimal
Due to the way the Query Editor works with a sample of the first 100 rows if there are no decimals it might defaulted it to a Whole Number.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Rangapbi,
Issue is in the excel. Check the format of the column.
I have tested this scenario in my local machine, i have got the values in Power BI as it is in excel.
Thanks !!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Pratheek,
Format is fine,once we create a report with the data it shows values correctly but when we update the sheet it is not reflecting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much! Was messing around with it for 30 minutes before I came across your response.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
02-26-2024 07:06 AM | |||
06-05-2024 10:40 AM | |||
09-11-2023 06:18 AM | |||
06-06-2024 11:09 AM | |||
07-24-2024 03:46 PM |
User | Count |
---|---|
124 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
180 | |
119 | |
82 | |
70 | |
54 |