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

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

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

  • 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.