Forum Discussion
Issue with Dynamic text in Textbox
- 10 months ago
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.
Hi samratpbi,
We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you.