Forum Discussion

kalcey's avatar
kalcey
Frequent Visitor
9 years ago

Decimal places on average, be gone!

Is there a way to get rid of the decimal point in an Whole Number column, where the average is calculated using the Visualisations pane?   I could add a measure sales (avg) = AVERAGE([Sales]) and f...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi kalcey,

 

You should be able to go to the Format tab -> Data labels, and set Decimal Places to 0 for that visual, then the average value should be shown as whole number without the decimal point.:smileyhappy:

 

 

Regards

rogerta's avatar
rogerta
Icon for Advocate I rankAdvocate I
8 years ago

What about card visualisations - it doesn't have that option.

 

I'm averaging a series of whole numbers and displaying in a card visual and want to get rid of the decimal places.  Why is the default to have decimals in the first place for an average - doesn't make sense to display an average with decimal places in the first place.

 

This should not be this difficult!

  • rogerta's avatar
    rogerta
    Icon for Advocate I rankAdvocate I
    8 years ago

    Solved it in the end by re-formatting the data type to "Fixed decimal number" in the Modelling tab 

    • BartEdgerton's avatar
      BartEdgerton
      Icon for Advocate I rankAdvocate I
      8 years ago

      The entire Formatting section of the Modeling tab is grayed out.  Any other ideas?  None of this is working..

      • Drors's avatar
        Drors
        Icon for Resolver III rankResolver III
        8 years ago

        You should click on the spacific column before you go to the modeling tab, then you will be to remove the decimal point or to change to column type

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      OMG... Thank you so much, I was going crazy.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks, great idea, worked for me.