Whole numbers in average

[Beiffon]

HI,

I have an Attribute Slicer for an Average.

I only wan to show Whole Numbers

 

Any ideas on how to do this?

Thanks in advance,

[Phil_Seamark]

One way is to set the number of decimal places in the field formatting of the column to 0

Or if you are using a DAX calculated measure to generate the average, you can wrap your formula with an INT function

[Beiffon]

Thanks, but the visual I am using does not have that option 😞

[Phil_Seamark]

What sort of field are you using in your slicer?  A calculated measure, or are you dragging a table column to the visual?

[Beiffon]

A table column

[Phil_Seamark · Accepted solution]

Please select the table column in the field list so it has a yellow box surrounding the field.  This is just to select the field.

Then in the modelling tab on the ribbon, use the Formatting options to either convert the number to an Integer, or see if you can set the number of decimal places to 0.

[Beiffon]

awesome, thanks mate