Forum Discussion

Beiffon's avatar
Beiffon
Frequent Visitor
8 years ago
Solved

Whole numbers in average

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,
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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.

     

     

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

Beiffon's avatar
Beiffon
Frequent Visitor
8 years ago

A table column

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Beiffon
      Frequent Visitor
      8 years ago

      awesome, thanks mate