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