Forum Discussion
decimal places in matrix
I have a number of Matrix visualizations drawn from measures that are showing whole numbers with two decimal places. I need to remove the decimal places. How do I remove the decimal places? I can't d...
Ok, In the report view, Select or click on the Measure from the Fields , Then got to Modelling , change the format as required. It should be enabled.
I guess earlier you didnt select the Measure in fields before navigating to Modelling, thats why it would have been Greyed out.
Thanks
Raj
Hi MarkSL
No I've not found a fix for it. I've just lived with having the 2dp.
To me its seems its something MS should fix
Stuart
I had this issue and solved it by.
go to the measure that you are using in the values field of your Matrix.
Then on column tools set the structure Data Type to Decimal number and set the Formatting, Formate to Whole number but with 0 decimal places