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

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.