Forum Discussion
Power BI Dynamic Format strings not working in Excel Pivot Table report
I followed the examples in the SQLBI.com article (SQLBI Introducing-dynamic-format-strings-for-dax-measures ) to add formatting to a currency measure which adds the currency code.
This works fine in Power BI Desktop and in a Power BI report linked to the published dataset;
In Excel, connecting to the published dataset and inserting a Pivot Table, the formatted measure does not work. The measure returns just the numerical value without the formatting;
Is there a way to turn this feature on in Excel pivot table reports?
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
4 Replies
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
Thanks Rita.
Subsequently, I have found that the same problems occurs in DAX Studio meaning that the formatting string is not used in either MDX or DAX queries outside of Power BI.
It looks like this was never meant to be a feature other than within Power BI reports.That makes sense. It's a feature that's also available in Power BI but is still under Preview Features, so it's not surprising that it's not present in other tools yet.
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
