Decimal points is always showing after data export in csv file

[Anonymous]

Hi,

I set custom format of measure "#,##0.##;-#,##0.##;0;".

Correctly showing in power bi report.

But after exporting data to csv file and while open taht csv file decimal value is always showing.

I don't want to display demical points when it is an integer.

Left: Power BI Service

Right: export csv

I need to make the number of decimal places variable.

Integer,First decimal place,Second decimal place.

ex.)

slicer select integer

 1 -> 1

 1.6 -> 2

 1.25 -> 1

slicer second decimal place

 1 -> 1

 1.6 -> 1.6

 1.25 -> 1.25

approach

 1.select slicer(Integer,First decimal place,Second decimal place)

 2.round in measure

 3.custom format <- problem occured

Data

 Value Custom Format:"#,##0.##"

1.23

1

1.2

1.34

a

[amitchandak]

@Anonymous , Try format like

"#,##0.00;-#,##0.00;

Also check by changing format in csv , if opened in excel

[Anonymous]

Thank you for reply.

I need to make the number of decimal places variable.

Integer,First decimal place,Second decimal place.

ex.)

slicer select integer

 1 -> 1

 1.6 -> 2

 1.25 -> 1

slicer second decimal place

 1 -> 1

 1.6 -> 1.6

 1.25 -> 1.25

approach

 1.select slicer(Integer,First decimal place,Second decimal place)

 2.round in measure

 3.custom format <- problem occured

[v-shex-msft]

Hi @Anonymous,

Can you please share a pbix file or some dummy data and Dax expressions? It should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng