Forum Discussion

TM_Visual's avatar
TM_Visual
Icon for Advocate III rankAdvocate III
2 years ago
Solved

When adding a dynamic value to a text box, some measures do not appear in the list of options

I have a report with a lot of measures. In a text box, I have selected '+ Value' to add a dynamic value to the box, and the 'ask a question about your data' box allows me to start typing and intellis...
Need Help
  • v-weiyan1-msft's avatar
    v-weiyan1-msft
    2 years ago

    Hi TM_Visual ,

     

    Please try to keep your version of Power BI Desktop up-to-date to avoid problems caused by the version.
    Hidden measures will not appear in the list of options, Please check that the measures you are trying to access are not hidden from the report view.
    Based on your description, you can also check the metrics [FTE Enrol] and [FTE Enroll 2021] for any syntax errors or problems. These errors may prevent them from appearing in the list of options.
    I also found a similar post, please refer to it and see if it helps you.

    Solved: Q&A new measures not recognized - Microsoft Fabric Community

     

    Best Regards,
    Yulia Yan

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

I encountered the same thing yesterday. Looks like the text box visual only accepts measures declared as type text. Add a string to your measure result

 

Measure = divide(a,b,0( & " "

 

Or use FORMAT.