Forum Discussion
Numeric Fields Appearing as Text in Excel PivotTable
Hello! Thank you for your answer. I solved the problem by creating a calculated measure in Power BI. Unfortunately, simply using the numeric format does not help. It is displayed in the desktop version, in Power BI service, but in Excel it is still text. But the calculated measure is OK. It works. I solved the problem like this. If that is what you meant, then it works.
Hello! Thank you for your answer. I solved the problem by creating a calculated measure in Power BI. Unfortunately, simply using the numeric format does not help. It is displayed in the desktop version, in Power BI service, but in Excel it is still text. But the calculated measure is OK. It works. I solved the problem like this. If that is what you meant, then it works.
Hello AnnaBasova
Glad to hear that your issue is resolved! Kindly accept the solution so that it can help others easily find and apply the fix.
Regards,
Karpurapu D.