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
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 solutionClick 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
