Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Text box is not recognising measure

Hi,

 

I have created a simple measure to dynamically update a report heading (I want it to display the client name when a single client is selected, but show as 'All Suppliers' when no selection has been made):

 

Report Title = if(HASONEVALUE('DIM Client'[Name]),values('DIM Client'[Name]),"All Suppliers")
 
However, when I attempt to add this value to a text box in Power BI desktop, it does not recognise the measure. I have tried checking the QA option suggested in another post, but this doesn't work.
 
This issue is only occurring on this .pbix file, but I am not able to share the file due to the sensitive client data within it. Any suggestions?
Status: Needs Info
Comments
Anonymous
Not applicable

Hi @BITomS 

You mean, if you use the same DAX in other pbix files and add it to the a text box , there is no problem is there?

 

Best Regards,
Community Support Team _ Ailsa Tao

BITomS
Responsive Resident

@Anonymous 

 

Correct

HeathS07
Regular Visitor

I have this issue as well - it was working fine in one report, I copied the tables' code and DAX into a much larger file (so I can't apply the changes to that file instead). I've been able to show it in a card without issues, all column types are matching... I'm stumped.

testing1499
Regular Visitor

I have this issue as well, after Nov2023 update the text box does no longer accept a "+Value" measure input.
When installing an older version it seems to be working fine.
Seems there are few others facing same issue as well: 
https://community.fabric.microsoft.com/t5/Desktop/Cannot-add-dynamic-values-into-text-box/td-p/35494...

This widget could not be displayed.