Currently, dynamic format strings for DAX measures, such as adding currency codes, work perfectly in Power BI reports but are not supported in Excel Pivot Tables connected to published datasets. When connecting to a Power BI dataset in Excel, the measures return only the numerical values without the dynamic formatting.
This feature would greatly improve the user experience in Excel by maintaining consistent formatting between Power BI and Excel reports. It would be beneficial for users who rely on both platforms for reporting and analysis.
We request the addition of support for dynamic format strings in Excel when connecting to Power BI datasets, ensuring that users can view the same formatting in both Power BI and Excel.
2 Comments
Without the ability to carry these formats all the way into Excel from PBI semantic models users will just go around the model and create their own versions, defeating the object of the whole exercise. Please let's get this upvoted and done.
- Status added:New
