Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
smess_cle
New Member

My data has no decimal in my table

Hello to all,

 

I wonder how to have the data in my table with decimal numbers.

I have multiple columns, all of them have decimal except for 1 of them (and I am sure that this particular data has decimal as I am displaying it on different graph with decimals).
I can't see any formating option in the table parameters.
Thanks for your help

2022-10-04 09_44_07-ALBA Power BI - Power BI Desktop.png

1 ACCEPTED SOLUTION
Tiemen
Advocate II
Advocate II

You can change the number of decimal places in the formatting menu of the table for each measure. 

Tiemen_0-1664884589651.png

 

View solution in original post

6 REPLIES 6
Tiemen
Advocate II
Advocate II

You can change the number of decimal places in the formatting menu of the table for each measure. 

Tiemen_0-1664884589651.png

 

Thanks @Tiemen, this is exactly what I was looking for!

Dinesh_Suranga
Continued Contributor
Continued Contributor

@smess_cle ,

Hi,

1st - Go to data table view (Click table button in left side)

2nd - Select the column you need to format (From tables in right side)

3rd - Change format to Decimal Number.

Dinesh_Suranga_0-1664862766737.png

 

Thank you.

Thanks for your answer but this table is a table of multiple measures.
what you showed me doesn't work.
Any other idea?
(and I am sure the value are decimals value as I display them on a graph and it shows me decimal values)

@smess_cle 

Hi,

Is your value coming from a table column or from a measure?

Thanks.

 

It is coming from a measure

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.