Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerBI Matrix Format - Fixed Decimal Number

PowerBi Matrix displays the values with additional decimals although Query has adtional step to format the cells as Fixed Decimal Number (Currency $).   How can I force the matrix to display only t...
Need Help
Show and Tell
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

    Table:

     

    You may create a measure like follows.

     

    Result = ROUND(SUM('Table'[Score]),2)

     

     

    Then you may make the measure selected, go to 'Modeling' ribbon, set 'Decimal places' as 2.

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Anonymous 

 

Based on your description, I created data to reproduce your scenario.

Table:

 

You may create a measure like follows.

 

Result = ROUND(SUM('Table'[Score]),2)

 

 

Then you may make the measure selected, go to 'Modeling' ribbon, set 'Decimal places' as 2.

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It was fixed only after rounding to zero digits. Thank you.