How to add text paragraphs as a visual in Power Bi report?

[dinesharivalaga]

Hi All,

I have some text columns like Accomplishments , Scope and so on for each accounts. 

Have created a slicer with all account names , so i have to add those Accomplishments , Scope columns having text as a paragraphs into the visual in power bi report.

When i change the account name in slicers then the text also should change as per selected accounts.

Actually those text data were pulled from sharepoint list.

What kind of chart we should use in that case ? 

Please help to fix my query , thanks in advance ..

BR

Dinesh

[Anonymous · Accepted solution]

Thanks for the reply from @christinepayton  @ChiragGarg2512 , please allow me to provide another insight:

Hi @dinesharivalaga ,

You can try formula like below:

M_ =
IF (
    ISBLANK ( SELECTEDVALUE ( 'Table'[Account Name] ) ),
    "please choose account",
    SWITCH (
        SELECTEDVALUE ( 'Table'[Account Name] ),
        "Account 1", "Account 1 - Completed project ahead of schedule. - Expanded product line.",
        "Account 2",
            "Account 2 - Exceeded sales targets for the quarter. - Implemented new marketing strategy.",
        "Account 3",
            "Account 3 - Secured major contract with new client. - Launched successful advertising campaign."
    )
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[christinepayton]

I would put it in a table. You can also insert some dynamic data into text boxes, but that doesn't sound like what you're trying to do here per se. Tables are much easier to work with generally. 

[ChiragGarg2512]

If it is just a paragraph and they are part of the column, a card visual should do the trick.