In the Fields pane, expand the Sales table. ROUNDDOWN Then on column tools set the structure Data Type to Decimal number and set the Formatting, Formate to Whole number but with 0 decimal places. Figured out that I had the card selected, and not actually the measure under fields. As you said, this has nothing to do with Format (i.e. How to remove decimal places from a power automate 01-19-2022 05:03 AM I have a calculated column used in getting the difference between Actual Qty received and Initial Qty delivered. go to the measure that you are using in the values field of your Matrix. How do you ensure that a red herring doesn't violate Chekhov's gun? Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Though it's still unclear to me that why this happens when Field1 has the data type Fixed decimal number, but not CField. FIXED function (DAX) - DAX | Microsoft Learn The following formula rounds 21.5 to one decimal place to the left of the decimal point. Lets say I have a table "Table1" with field Field1, "Table2" with Field2. I can easily get rid of all digits wherever they are, using this action: adding a custom column: Then the expression below (remember to use your column name instead of Column1 in the below expression): Digits would be removed regardless of where they are in the text easily using the Text.Remove Power Query Function. Remove Digits or Keep them in Power BI Using Power Query, Power BI Architecture Brisbane 2022 Training Course, Power BI Architecture Sydney 2022 Training Course, Power BI Architecture Melbourne 2022 Training Course, Q&A Visual Define an Adjective for a Column. The July 2020 version of Power BI Desktop allows you to create calculation groups in Power BI Desktop, thanks to the new Oksana October 14, 2020, 9:44am #5 You could try creating a calculated column using SUBSTITUTE and then change the data type to be whole number. Dynamically change the format of values in Power BI I made my first project on Power BI. I would be very grateful for some Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Did you know we have a LinkedIn page? View solution in original post Message 2 of 3 632 Views 1 Reply display issue). I did not think it would be possible to lose these decimal points, because it technically is neither text nor number but rather it floats between the two.