Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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.
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.
Yes. thank you
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
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:
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |