Forum Discussion

samratpbi's avatar
samratpbi
Super User
10 months ago
Solved

Issue with Dynamic text in Textbox

Hi, I am trying to have a text with some dynamic inputs in between. Those Dynamic Inputs I am adding from measures. The problem is some of the measures are not working properly.  Please note, some me...
  • v-pnaroju-msft's avatar
    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:

    1. Update to the latest Power BI Desktop, as new releases often include fixes for Q&A and text box integration.
    2. 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.
    3. 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.
    4. 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 Learn

    We 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.