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

foyiq's avatar
foyiq
Icon for Advocate I rankAdvocate I
9 years ago

v-ljerr-msft what about the same for matrix preview, where there is no option to set decimal places in format tab?

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

    foyiqHave you found any solution ..?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      For a table, it's under 'Specific Column' > 'Values' > 'Value decimal places'