Decimal places on legend is different than decimal places on chart on a bar chart

[Anonymous]

Dear Community

i have a bar chart with a Color Scale Data Colors based on an average.

the legend would then show max and a min both with 2 decimal places.

However, the rest of the data is whole number everywhere.

how can i change the legend to be whole number

thank you

[amitchandak]

@Anonymous , Assume you are using measure M1

Create m2 = round([M1], 0)  

 and use that only in color scale

[Anonymous]

im not using a measure