Hide Decimals in table

[cbritocr]

Hello!

I have a table with a measure decimal but I need that in a table hide them, and that in the moment of export data keep the decimal?

The problem that I have is that if I hide the decimals in the formats tool of the Power BI Desktop, in the table show the numbers without decimals, but when I export de data to Excel, the data export like integer and I need keep the decimal.

[Stachu]

Set the 'Data Type' to Decimal Number and the 'Format' to Whole number

[cbritocr]

Thanks, but I already made the configuration but it does not work with the export in Excel, when I export to Excel the measure is Whole number and not decimal.

[v-huizhn-msft · Accepted solution]

Hi @cbritocr,

First, in Power BI desktop, we only can export to .csv file. And we only set the format not data type as the screenshot shown. We can set the data type and format of columns.



Second, you said you export it in excel. I test it in Power BI service, we can export into excel. I set the measure's format as whole number, and publish it to service, then export it to .xlsx excel file, it shows whole number and not decimal. While when you set the digital, it shows correctly.



Best Regards,
Angelia