Measure Dynamic formatting doesn't work in reports connected to PBI dataset

[ERD]

Hello!

I used Dynamic formatting for measures and it worked fine as long as the report was in the same file as a dataset. But now we need to create separate PBI reports and connect them to the existing dataset. Unfortunately, it doesn't work if we create a measure in a report which is live connected to a Power BI dataset.

Is it a bug or know issue?

Please, advice.

Thank you.

[v-xiaoyan-msft]

Hi @ERD ,

It's a known limitation，Dynamic format strings for measures are only for model measures. Report measures that can be added to a live connect report can't have dynamic format strings for measures.

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Best regards.
Community Support Team_ Caitlyn