Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Advocate I
Advocate I

Dynamic Format String (preview) - not working in a report live connected to dataset

The new preview feature of dynamic format strings for measures only appears to work if the measure is created within the Power BI dataset.

It will not work if I create a measure in a report which is live connected to a Power BI dataset.

It will therefore also not work if I create a measure in a report which is live connect to an AAS model.


I would like to know if:

a) this is a known issue

b) there is a plan to enable this in reports, not just datasets, so that dynamic format strings can be set on measures stored in the report rather than the data model

Frequent Visitor

Same to me.  The weirdest thing is that you actually can create the dynamic format, but doesn't work and cannot change the string after.

But if you try to change from Dynamic to another format, appears the warning message that you will lost the format string if you change it

So, I think this is a bug 

Frequent Visitor

This needs to be looked in to. With most enterprise reporting being based of 'base' datasets, not being able to apply the dynamic formatting in reports based upon these datasets makes the feature useless for a large user group.

If this is important to you please consider voting for an existing idea or raising a new one at

Frequent Visitor

Second this, its already such a powerful feature but hindered currently on this problem

New Member

Wondering the same thing, as this would alleviate a major headache. 

New Member

I was wondering the same thing, would be great to have this enabled for measures in reports.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors