Changing a measure in a matrix to % with out a decimal point

[Roinka]

Hi Everybody,

I have a matrix in which one of the columns should be displayed as %.

The column is a measure.

How do i change this to a % and also make sure its a whole numbe like 5% or 4% without a decimal point?

I have noticed i have the option of "Field Formating" under Format in the report window when marking the matrix but for some reason it is grayed out.

Thanks.

[Greg_Deckler · Accepted solution]

Is this import mode or DirectQuery?

Generally you click the % formatting option and then reduce the decimal places to 0.

You might try using the FORMAT function.