Showing results for 
Search instead for 
Did you mean: 
New Member

Dynamic Values breaking on certain rows only

Hi folks,


I have a report that uses several text boxes with defined Dynamic Values to deliver information about rows of data from a single table. 


These have worked flawlessly across the board for the past several months, but recently I found there's at least one row of data they simply don't work on - the dynamic value returns the "no value" error symbol. The data is there; I can drop a table in the report with the same filtering and all the values show up. But the Dynamic Value queries just break - only on this one row. There are no query errors in my data and all other forms of reporting work fine on this row.


Compounding this challenge is the fact that there seems to be no formal documentation for this feature, and I can't find a way to troubleshoot by viewing the underlying query.


Appreciate any guidance on ideas for what might be breaking or ways to troubleshoot this rather opaque piece of functionality. Thank you!

Community Support
Community Support

HI @igriff,

Any update on this? Can you please share some more detail information about this? They should help us clarify your scenario and test.

How to Get Your Question Answered Quickly  


Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User
Super User

 a report that uses several text boxes with defined Dynamic Values

Can you explain a bit more what you are doing here? Can you provide an example?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors