Forum Discussion

amaiaita's avatar
amaiaita
Regular Visitor
3 years ago
Solved

Setting the Number Format Works For some cells and not others

When attempting to format numbers in a certain way on Power BI Report Builder (and the sample values come out as follows): 

 

If I then run the report the numbers don't format the way they should and have no formatting whatsoever:

 

 

  • Hi amaiaita ,

     

    There are a few possible steps you can try to troubleshoot the issue:

    • Check the data type of the field that you are trying to format. If the field is not a numeric data type, you may need to convert it to a numeric data type before you can apply number formatting.
    • Check the formatting settings for the field that you are trying to format. If the field has a custom formatting rule applied, you may need to modify or remove the rule in order to apply the desired formatting.
    • Check the formatting options for the visual that you are using to display the data. Depending on the type of visual you are using, you may need to enable or disable certain formatting options in order to apply the desired formatting.

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support

    Hi amaiaita ,

     

    There are a few possible steps you can try to troubleshoot the issue:

    • Check the data type of the field that you are trying to format. If the field is not a numeric data type, you may need to convert it to a numeric data type before you can apply number formatting.
    • Check the formatting settings for the field that you are trying to format. If the field has a custom formatting rule applied, you may need to modify or remove the rule in order to apply the desired formatting.
    • Check the formatting options for the visual that you are using to display the data. Depending on the type of visual you are using, you may need to enable or disable certain formatting options in order to apply the desired formatting.

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

    • amaiaita's avatar
      amaiaita
      Regular Visitor

      The first of your suggestions worked. For whatever reason the output of the SQL query giving the data was outputting the values as strings rather than integers, so putting CInt() in front of the value of the cells that were causing issues worked! Thanks 🙂