How to get original value( not rounded) in tabular

[Anonymous]

In the report I'm working with the 2 decimal number is rounded . For example 2,087 is rounded to 2.09
How can I change it in tabular Fact table so instead of 2.09 shows the original value 2.08?

[Anonymous]

To work around this problem, manually set the Field Size property of the column to Double or to Decimal.

1. Click the DataSheet tab. In the Views group, click the arrow under View, and then click Design View.

   Note If the table has not already been saved, you will be prompted to save the table with a table name that you provide.

2. Locate the column that you want to change, and then set the Field Size property of the column to Double or to Decimal.

[amitchandak]

Use trunc

https://docs.microsoft.com/en-us/dax/trunc-function-dax

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[Anonymous]

Thank you @amitchandak  for your reply but I don't want to remove fractional part of the number, I need it.

[amitchandak]

visualization format option search for value Decimal Place or Decimal place and provide the same.

[Anonymous]

I'm using tabular fact and dimension tables, Visualization format option has some options for color and nothing for value Decimal. Formatting option in report is not active to use either.Everything should be changed in tabular.

[amitchandak]

Check

[Anonymous]

As I mentioned in my previuos reply this option is not active in report and I only can change thing in tabular tables.