Forum Discussion
Helper IVRemove Decimals In Table
You can go to the data view, select the appropriate column, and then select the Modeling ribbon and then formatting tab. You can either change to a Whole Number or reduce Decimal Number to show 0 decimal places.
Impactful IndividualYou can go to the data view, select the appropriate column, and then select the Modeling ribbon and then formatting tab. You can either change to a Whole Number or reduce Decimal Number to show 0 decimal places.
How would i do this using directy query instead of import- How would i remove decimals if im using direct query
I might be answering this question too late, goto Edit query->Transform -> Data Type -> Fixed decimal number . The value changes from type number to the accounting type($) . Right click on the variable,->transform -> round to remove the decimal points.
- tjd
I don't really know since I've never used direct query with PowerBI. If you can't do it the same way as above, you might want to try duplicating the column after you're hooked up to your data and then trying to format the new column/table.
thanks this was driving me crazy!!
How do you set the decimal number to zero decimal places? I see only "decimal number" and "fixed decimal number" neither with any variability. Fixed Decimal Number forces two decimal dollars wtihout options. Decimal Number forces float without options and without dollars. Only other Data Types available are Whole Number, Percentage, and the even less relevant kind.
