Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
    stuartpearson
    8 years ago

    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

StevePBennett's avatar
StevePBennett
Icon for Advocate I rankAdvocate I
5 years ago

** For specific numbers of decimal places - As per rajendran's comment above - I've added the step (Select your Value Column), I didn't notice you could set for each value differently at first. So...

Go to the Visualizations -> Format tab- > Go to Field Formatting-> Select your Value Column (1st drop down) There is a parameter lower down 'Value decimal places'.
Make the changes here. Just type a number into the field. 


** For Zero decimal places - Edit the query and right click the header of your data column -> Select Change Type -> Select Whole Number.


Hope this helps.