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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Not a nice solution, but I added a measure = AVERAGE(column) and there "No calculation" is selected and 0 decimals works, it gives the proper number too.