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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

0

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

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.

ERD_0-1711386090100.png

 

 

Thank you.

Status: Delivered

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

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