How to format numbers with different length decimal places. Or how to remove ".00"

[AEdmonds1990]

Hello,

I have data of mainly whole numbers but with some quarters and halves:

1

2

4

19

2

3

1

1.5

8

3

1

1.25

The column containing this data has data type "Decimal Number" in the data view, and format type "General". Now in the data view this looks fine, however in my Reports it looks like:

1.00

2.00

1.50

1.25

etc.

This is annoying seeing as most of my numbers are whole numbers. Is there any way I can have this in the Report looking like the first like? This is how the numbers look in the Data View but not in the Report View which is annoying, and it feels like this should be a simply operation.

I have searched the web. I have found you can do it if you format the data as Text, but then this prevent me from doing any kind of conditional formatting on the values.

I also tried inserting a new column with a DAX statement to round the number to 0 decimal places if it is an integer. Again, it looks good in the data view, but in the report it still shows ".00" on most of my data.

[amitchandak]

@AEdmonds1990 , In column/measure tool there is an option for format

write the format there

#.00

[AEdmonds1990]

Yes in format I can either:

A) Format as "General"

This shows the numbers correct in Data View, but in the Report every number still has two decimal places.

B) Format as "Decimal number" with two decimal places

Doing this shows both the numbers in the Data View and Report as having two decimal places.

As far as I can see, no format option for a variable number of decimal places.

[user10456]

The box that says "General" is a free text box, you can type the format code in there and Power BI will use it.