Why are fields in greyed out when I try to add text to button conditionally?

[tvaishnav]

I am using live connection.

I have a measure that returns text I want to use as a text on button. I am using button instead of card because card does not have alignment feature. But all the fields are greyed out. What could cause this?

What is the best way to display a sentence in Power BI? The sentence includes DAX calculation.

[parry2k]

@tvaishnav you don't get the option to add measure in the textbox? When I add a textbox, I have the option to add values, do you see it on your end?

[Twinkle_R]

Hey @tvaishnav , to be able to add a measure as a tooltip, it must be of 'Text' format as tooltips accepts only that. Like in the image given below, please check what the format is set to and if Text it should not grey out. Thanks!

> Please give a thumbs up if my solution helped you!

[tvaishnav]

I see that but can't seem to add value. I see this.

I see that some versions of Power BI require to set language under Modeling tab but that option is greyed out as well since I am using live connection.

[v-janeyg-msft]

Hi, @tvaishnav 

There are many restrictions in live connection mode, Or you can try to have only variables in measure, and write the text content directly in the text box. (Add the text and measure to the textbox respectively)

If it doesn't work. In your case, If card visual can display the results you want, maybe you can consider using card in combination with the textbox.  (Use two visuals to display all the results you need)

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _Janey

[parry2k]

@tvaishnav you can use textbox and add measures to it

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[tvaishnav]

Thanks for the response @parry2k . That was the first thing I tried but measure just won't get added. This is how my measure is defined.

EstCostvsFCCost = "Forecast Cost is " & Format(Divide(sum(Fact_ProjCost[Forecast Cost]) - sum(Fact_ProjCost[Estimated Cost]),sum(Fact_ProjCost[Estimated Cost]),0),"0%") & " away from Estimated cost."