cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
om_eraydin Frequent Visitor
Frequent Visitor

Multiple Dynamic Data in Text Box

Hi,

 

I want to create a text report like;

 

Dear [CompanyName];

 

Your last order date is [LastOrderDate]. If you need new [NewItem]....

 

etc. etc. et.c

 

I want to fill the areas between [ ] tags from the database. I tried to create measure. However id did not worked for me. I want to create a table that has all companies, all last order date and all new items. When I click a single value report shoul be filled this value. For example;

 

Companies | Last Order Date | New Item

Apple         | 05/05/2017        | Phone

Microsoft   | 06/06/2017        | Computer

IBM            | 07/07/2017        | Laptop

 

When I select first row I want to see these information in my report. 

 

Is this possible? Is there anybody who tried to do sometinhg like that?

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: 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.

1.PNGselect the first row in table2.PNGselect the second row in table

Best Regards,
Angelia

4 REPLIES 4
Super User
Super User

Re: Multiple Dynamic Data in Text Box

I see no reason why not. Personally I would use MS Word. I guess you could connect to power BI.  Certainly you could extract a spreadsheet using Analyze in Excel and build a mail merge from there. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
om_eraydin Frequent Visitor
Frequent Visitor

Re: Multiple Dynamic Data in Text Box

Thanks for answer but I want to create this report in Power BI. Using  MS word, MS excel etc is not my first choice.

v-huizhn-msft Super Contributor
Super Contributor

Re: 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.

1.PNGselect the first row in table2.PNGselect the second row in table

Best Regards,
Angelia

om_eraydin Frequent Visitor
Frequent Visitor

Re: Multiple Dynamic Data in Text Box

Thanks Angelia. This is the exact solution I needed.