get textbox text and concatenate

[adityavighne]

Hi team,

I want to get textbox text and concatenate with dropdown value

e.g. textbox has the text " power bi" and dropdown have selected value "2.0"

output required is "power bi\2.0"

regards,

aditya vighne

[Icey]

Hi @adityavighne ,

You can refer to this blog: DAX – Concatenating Values only when values are selected.

Best Regards,
Icey

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

[adityavighne]

Textbox doesn't have any selection. it's a free text.

[Icey]

Hi @adityavighne ,

Do you mean that you want to get what is in textbox by DAX? Based on my knowledge, it is not supported in Power BI.

Best Regards,
Icey

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

[adityavighne]

Yes. thank you

[sturlaws]

Hi,

text boxes are static, and it is not possible to capture a value from a text box, or to add dax code to a text box.

You might want to look at the Card visual, which will allow you to create your desired output:

measure =
CONCATENATE (
    "power bi";
    IF (
        HASONEVALUE ( table[column] );
        CONCATENATE ( "/"; SELECTEDVALUE ( table[column] ) );
        BLANK ()
    )
)

Add the measure to a card visual, and in the formatting options of the visual, set category lable to off

[adityavighne]

@sturlaws 

power bi is text entered in a textbox....this is not static...

I want to get the textbox value and then concatenate

[sturlaws]

Sorry if I misunderstood you, but if you by textbox mean this feature in power bi desktop:

it is in terms of DAX static. You cannot reference such a text box in DAX, and a text box cannot contain dax or measures.