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 do it through the Modeling menu from Table view because the measures don't show in the table. I can't do it through the Modeling menu in the report view because the formatting options are grayed out. How do I remove the decimal places?

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

14 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Go to the Visualizations -> Format tab- > Go to Field Formatting-> There is a parameter 'Value decimal places'. Make the changes here.

     

    Hope this helps.

     

    Thanks

    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Value Decimal Places in Field Formatting is set to Auto and grayed out so I can't change it.

      • Anonymous's avatar
        Anonymous
        Not applicable
        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

  • StevePBennett's avatar
    StevePBennett
    Icon for Advocate I rankAdvocate I
    5 years ago

    ** For specific numbers of decimal places - As per rajendran's comment above - I've added the step (Select your Value Column), I didn't notice you could set for each value differently at first. So...

    Go to the Visualizations -> Format tab- > Go to Field Formatting-> Select your Value Column (1st drop down) There is a parameter lower down 'Value decimal places'.
    Make the changes here. Just type a number into the field. 


    ** For Zero decimal places - Edit the query and right click the header of your data column -> Select Change Type -> Select Whole Number.


    Hope this helps.

  • 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

     

     

     

  • LukePetersen's avatar
    LukePetersen
    New Member
    3 years ago

    I had this issue and solved it by. 

    go to the measure that you are using in the values field of your Matrix. 

    Then on column tools set the structure Data Type to Decimal number and set the Formatting, Formate to Whole number but with 0 decimal places