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

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors