Forum Discussion
Format number in matrix without changing data model
Anonymous wrote:
Hi!
I have a matrix showing the average revenue per category. The revenue in my data model is formatted without any decimals. Still, in my matrix I get 2 decimals on my average.
How do I format this number in my matrix without changing my data model (cause that is not helping).
Thanks!
Anonymous
You can try to format the measure by changing decimal places
I cannot format any numbers. And in the data model is it already without decimals.
Im encountering the same issue. However, it seems when i duplicate the table or create a new table, and click on any area of the screen my formating appears!
Still in need of a proper solution
Click on the paint brush under visualizations, select data label, display units, change to None and 0 Decimal places.
I had the same issue. You just need to select the data field in the Fields menu area (if this is a measure you will see the formula displayed too at the top) and this will unlock the format menu
