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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

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