Forum Discussion
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 format it as Whole Number, however I am trying to avoid adding more measures.
Thanks
14 Replies
v-ljerr-msftMicrosoft Employee
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
- v-ljerr-msft
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
Advocate I
v-ljerr-msft what about the same for matrix preview, where there is no option to set decimal places in format tab?
Naveen_KumarfoyiqHave you found any solution ..?
- rogerta
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
Solved it in the end by re-formatting the data type to "Fixed decimal number" in the Modelling tab
