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

  • kalcey's avatar
    kalcey
    Frequent Visitor
    9 years ago

    Thanks v-ljerr-msft !

     

    What about when the value on the bar graph -or the tooltip- is an average?

     

     

     

     

    • v-ljerr-msft's avatar
      v-ljerr-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Hi kalcey,

       

      The value shown on the bar graph should be changed to whole number by using the solution I mentioned above.

       

       

      However, there is currently no options to change the data label format for the value or the tooltip shown up when hovering over on the bar graph. You can vote the idea here.: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'

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