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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adityavighne
Continued Contributor
Continued Contributor

get textbox text and concatenate

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

7 REPLIES 7
Icey
Community Support
Community Support

Hi @adityavighne ,

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

select.PNG

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
Continued Contributor
Continued Contributor

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

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
Continued Contributor
Continued Contributor

Yes. thank you

sturlaws
Resident Rockstar
Resident Rockstar

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

@sturlaws 

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

 

I want to get the textbox value and then concatenate

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

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.

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.