Forum Discussion
Power BI Dynamic Format strings not working in Excel Pivot Table report
Hi JonnieM2
Unfortunately, dynamic format strings for DAX measures, such as adding currency codes, are currently supported only in Power BI reports and not in Excel when connecting to a published dataset. While Power BI can handle these custom formatting strings, Excel currently does not support this feature and will display only the numerical value without the dynamic formatting.
As of now, this functionality is limited to Power BI, and there's no built-in option to enable it in Excel Pivot Tables.
I posted the issue as the idea please vote for it :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=26307de4-e290-ef11-9442-000d3a7d8d57
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi JonnieM2
Unfortunately, dynamic format strings for DAX measures, such as adding currency codes, are currently supported only in Power BI reports and not in Excel when connecting to a published dataset. While Power BI can handle these custom formatting strings, Excel currently does not support this feature and will display only the numerical value without the dynamic formatting.
As of now, this functionality is limited to Power BI, and there's no built-in option to enable it in Excel Pivot Tables.
I posted the issue as the idea please vote for it :
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=26307de4-e290-ef11-9442-000d3a7d8d57
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I will upvote but your Idea URL link misses the last character. Should be https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=26307de4-e290-ef11-9442-000d3a7d8d57