cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vozniak Regular Visitor
Regular Visitor

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 do it through the Modeling menu from Table view because the measures don't show in the table. I can't do it through the Modeling menu in the report view because the formatting options are grayed out. How do I remove the decimal places?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: decimal places in matrix

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

stuartpearson Frequent Visitor
Frequent Visitor

Re: decimal places in matrix

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

9 REPLIES 9
Super User
Super User

Re: decimal places in matrix

Go to the Visualizations -> Format tab- > Go to Field Formatting-> There is a parameter 'Value decimal places'. Make the changes here.

 

Hope this helps.

 

Thanks

Raj

vozniak Regular Visitor
Regular Visitor

Re: decimal places in matrix

Value Decimal Places in Field Formatting is set to Auto and grayed out so I can't change it.

Super User
Super User

Re: decimal places in matrix

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

vozniak Regular Visitor
Regular Visitor

Re: decimal places in matrix

I had to double click the Measure in the fields and then go to Modeling to get teh format option! Thank you!!!! Cat Happy

stuartpearson Frequent Visitor
Frequent Visitor

Re: decimal places in matrix

I can't get this to work completely.

I can set any number of decimal places above zero.

But if I set decimal places to Zero it displays 2 decimal places!!

 

This only happens when I set the field to average.

If set to sum then it works OK

MarkSL Member
Member

Re: decimal places in matrix

Hi @stuartpearson,

 

Did you find a fix for this?  I am using a Matrix and selecting Average but the result is defauting to 2 decimal places and I want none.  Going into the modelling tab will only allow me to go down to 1dp, changing it to zero results in 2dp as you have also found.

 

Thanks

 

Mark

stuartpearson Frequent Visitor
Frequent Visitor

Re: decimal places in matrix

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

AWentzEco Frequent Visitor
Frequent Visitor

Re: decimal places in matrix

Thank you. I had the same issue. Modeling tab wasn't allowing me to change the decimals on a Measure. Didn't realize you can't just highlight the field by clicking on it, have to CHECK the box next to the measure in order to view the Modeling Tab and update the formatting. Appreciate posts like this for newbies like me who have no idea if 'it can't be done' or 'operator error'. Smiley Happy

kyle_hermann Visitor
Visitor

Re: decimal places in matrix

the modeling tab doesn't change any of my data. the decimal places is stuck on auto.