Forum Discussion
Multiple Dynamic Data in Text Box
Hi om_eraydin,
In text box, we can not use measure. I suggest you add the measure in card visual. Please review the following steps.
1. Create a Table visual to display your table data.
2. Create a measure using the formula.Measure = "Dear"&VALUES(TT[Companies])&"Your last order date is"&VALUES(TT[Last Order Date])&"If you need new"&VALUES(TT[New Item])
3. Create a card visual to disply the Measure, when you select the first row in the table, the card will display the corresponding result.
select the first row in tableselect the second row in table
Best Regards,
Angelia
Microsoft EmployeeHi om_eraydin,
In text box, we can not use measure. I suggest you add the measure in card visual. Please review the following steps.
1. Create a Table visual to display your table data.
2. Create a measure using the formula.
Measure = "Dear"&VALUES(TT[Companies])&"Your last order date is"&VALUES(TT[Last Order Date])&"If you need new"&VALUES(TT[New Item])
3. Create a card visual to disply the Measure, when you select the first row in the table, the card will display the corresponding result.
select the first row in tableselect the second row in table
Best Regards,
Angelia
Thanks Angelia. This is the exact solution I needed.
hkiceAdvocate II
The issue here is that using a CARD will display the result that will be aligned in the CENTER , which is not always ideal when I may have some text in varing length from say 5 words to 20 words and it will look strange on the report where the 5 words text will be in the middle of the CARD and the 20 words text will be stretched fully into the CARD !!
