Forum Discussion

cbritocr's avatar
cbritocr
New Member
8 years ago
Solved

Hide Decimals in table

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 ...
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

cbritocr's avatar
cbritocr
New Member
8 years ago

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's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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