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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.