Forum Discussion

mmcgilvray's avatar
mmcgilvray
Frequent Visitor
9 years ago
Solved

How to Change number format in Matrix

I have Sales measures created in Power Pivot in Excel 2016 that are formatted to 1 decimal place.

When I use these in a Power BI (web version NOT Desktop) Matrix, they seem to be automatically formatted with 2 decimal places, but only in some cases.

Is there a way to change the number format in the Matrix Visulaisation?

thanks

Michael

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    This should be posted in Service not Desktop if you are not referencing the Desktop.

     

    I do not believe there is a way to change the format of the numbers in the Service. I would suggest that you import your Excel into Power BI Desktop, change the format in the data model and upload to the Service.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    This should be posted in Service not Desktop if you are not referencing the Desktop.

     

    I do not believe there is a way to change the format of the numbers in the Service. I would suggest that you import your Excel into Power BI Desktop, change the format in the data model and upload to the Service.