Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Format number in paginated report

I need to format a label (not textbox) with text: 4268 to 4.27. Can someone please help?

 

Thanks

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Markzolotoy ,

     

    you can format with the FORMAT function and the Excel-style formatting.

    So the following should give you the result you want:

    =Format(Fields!YourColumn.Value, "##0,.00")

     

    By the way, you can use the same format string for custom formatting in Power BI.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

1 Reply

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Markzolotoy ,

     

    you can format with the FORMAT function and the Excel-style formatting.

    So the following should give you the result you want:

    =Format(Fields!YourColumn.Value, "##0,.00")

     

    By the way, you can use the same format string for custom formatting in Power BI.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis