Forum Discussion

om_eraydin's avatar
om_eraydin
New Member
9 years ago
Solved

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...
General Comment
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
9 years ago

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. 

om_eraydin's avatar
om_eraydin
New Member
9 years ago

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