how can we display txt nd imges

[Anonymous]

hi

i have column which i created using unpivot option in powerbi but that contains imgs and some txt values together.

if i want to display imges i need to convert to imgurl option but then my txt will not display 

how can i overcome it so that i can display both the values.

[mahoneypat · Accepted solution]

You should pivot the values into different columns.  You can add a custom column with an if then else if it contains "http" and then use that to Pivot the column (with Don't Aggregate).

Regards,

Pat

[Anonymous]

hi mahoneypa

could u plz explain it clearly i didnt get u.can you plz tell me hoe to work on it.

[parry2k]

@Anonymous what is your data source? Is it a text file? if yes, can you use text by example. Here is a blog post to walk thru the process.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡