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

VP2023's avatar
VP2023
New Member
3 years ago

UPDATE - Newer PowerBI software - these options do not appear at all

 

you need to go to

 

1. Visuals

2. Format your visual

3. Under the "visual" tab - specific column

4. Apply settings - this will show your columns within the matrix table

5. Select Values

6. Value Decimal Places - change this to the number you require.

 

 

If the above doesn't work - please go into "Transform Data, find the data source and change the type to "Decimal Number). Once this is completed - just refresh the data and everything should be perfect