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
    7 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

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

stuartpearson's avatar
stuartpearson
Icon for Advocate II rankAdvocate II
8 years ago

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's avatar
    MarkSL
    Icon for Helper V rankHelper V
    8 years ago

    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's avatar
      stuartpearson
      Icon for Advocate II rankAdvocate II
      7 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
        7 years ago

        I have the same problem, with average in matrix.
        3DP set --> 3DP shown
        2DP set --> 2DP shown
        1DP set --> 1DP shown
        0DP set --> 2DP shown --> Why? Maybe some DAX can help...