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.
Hi AnnaBasova
We are pleased to hear that you have found the cause and resolved the issue. Thanks for sharing the details here. Please mark your insights 'Accept as solution' to help others with similar problems find it easily.
Thank you.