Forum Discussion
Issue with Dynamic text in Textbox
Thankyou, Greg_Deckler, for your response.
Hi samratpbi,We appreciate your inquiry on the Microsoft Fabric Community Forum.
Based on my understanding, the dynamic value feature in text boxes depends on the Q&A natural language engine in Power BI. In large models with many tables or measures, the Q&A index may fail to detect certain measures or may ignore filter conditions due to ambiguity, cache issues, or poor Q&A configuration.
Please follow the steps below, which may help to resolve the issue:
- Update to the latest Power BI Desktop, as new releases often include fixes for Q&A and text box integration.
- Re-initialise Q&A by adding a temporary Q&A visual and completing the Q&A setup. This refreshes the natural language index used by text boxes.
- Clear local caches by navigating to File > Options and settings > Options > Global > Data Load → Clear cache, then restart Power BI. This often resolves measure not found issues.
- For large models, use Q&A setup to exclude unnecessary fields and consolidate your measures in a dedicated Measures table.
If you require inline formatting such as bold numbers within sentences, a possible workaround is to insert multiple Value placeholders in the text box and format each one individually. Alternatively, you may concatenate values into a single DAX measure if consistent formatting is acceptable.
Kindly refer to the links below for further information:
Create a Q&A visual in a report - Power BI | Microsoft Learn
Limitations of Power BI Q&A - Power BI | Microsoft Learn
Best practices to optimize Q&A - Power BI | Microsoft LearnWe hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
samratpbi I generally create a new measure and use that in my Text boxes. Is that what you are doing or are you trying to use the "smart narrative" feature of the text box?
Hi Greg_Deckler Thanks for your reply. I am also doing the same; I created new measure and trying to use that in a text box. But when in the value section, trying to add, its not detecting some of my measures (those measures working perfectly fine in a card)
Thanks
samratpbi I generally have the best luck by specifying "[Measure Name]" in my Value area and then clicking on it once it is underlined. However, as I said, I almost never use Textboxes for this and instead use a Card visual. So if I wanted to say, "The maximum value for xyz is 40 as of 10/2/2025", I wouldn't do that in a textbox, I would create a measure:
Measure = "The maximum value for xyz is " & [Max Value Measure] & " as of " & TODAY()Then just plop that in a Card visual and you don't have to worry about the janky Textbox interface.
Hi Greg_Deckler thanks for your reply. I need different formatting for different parts of the text. e.g.
"as of 10/02, product value is 12345, STLY product value is 12367." Something like that.
I can put multiple buttons side by side and have different formatting for those, but that would not be very good implementation and allignment is not very seemless.
Would appriciate if you have any other suggessions. (noticed there is a PBI certified HTML textbox custom visual, however trying to avoid custom visual)
