ROUNDING UP/DOWN DECIMALS

Hi Piotr,

Welcome back to the forum!

Thank you for the question.

Just to be clear, you are asking if it's possible to set decimal places to zero on a value but for a visual, such as a matrix, to still show decimal places when displaying that value

The question I need to ask is 'Does the value need to show decimal places in some visuals but not in others?' If this is correct then we cannot just change the decimal places for a value as this change will affect visuals

The solution could be to create a calculated column using Power Query M to round up/down the value column:

1. From your Power BI report go to TRANSFORM DATA to launch the Query Editor

The column (eg. Sales Price) that has the values with decimal places needs to be part of a Power Query formula

2. Go to ADD COLUMN > CUSTOM COLUMN

3. Enter in the 'New Column Name' field 'Sales Price (rounded)

3. In the 'Custom column formula box type:

= Number.Round([Sale Price],0)


4. Set the new calculated column to whole number by going to TRANSFORM > DATA TYPE

5. Click OK and Close & Apply to return to the report view

Now you have the flexibility to choose which visuals can show decimals and which do not

I hope this helps with your question. Please let us know if this is the right solution for you

Kind regards
Martin