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:

      • AWentzEco's avatar
        AWentzEco
        Frequent Visitor
        7 years ago

        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'. :)