Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
While loading data from excel file to power bi. Decimals turned into round number.
My data is price of product so how to fix it.
Excel Data
Symbol | Series | Date | Prev Close | Open Price | High Price | Low Price | Last Price | Close Price |
TATACHEM | EQ | 16/Oct/18 | 649.8 | 657 | 687 | 654 | 676 | 676.55 |
TATACHEM | EQ | 17/Oct/18 | 676.55 | 678.2 | 686.6 | 663.75 | 667.7 | 670.1 |
While transforming the decimal turned into whole . I mean without decimal it showing. I tried fixed decimal and decimal too but not fixed solution.
Hello Punitha,
First of all, depending of your region Power BI use "." or "," as decimal separator.
You can still use the "Transform data" option to replace all your "." in decimal fields to "," in order to be able to use the decimal formating.
I hope this will help you find the right solution.
- Quentin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |