Sharepoint list images based on the column wise

[NadeemAhamed]

Hi Community

I have saved my images in Sharepoint List and made the column type to image

I have totaly 5 column such as Month (text), Division(text), PL_Remarks(image), BS_Remarks(Image), Priority Activity(Image)

When i am bring this list into PBI , i don't know how to bring the identify the image so that i can bring one image in one pages. Ex: PL_Remarks images in PL pages and BS_Remarks image in BS page. 

i have slicer for Month and Division so that the i hope the images also get change based on the slicer.

[Anonymous]

Hi @NadeemAhamed ,

Could you please provide some screenshots of the error? If you just want to show sepcific Image in PowerBI, you can create below measure and put it on where you want want to show it.

Measure = CALCULATE(MAX([PL_Remarks]),'Table'[Division]="Admin")

Best regards,

Mengmeng Li

[NadeemAhamed]

@Anonymous 

I would be greatly appreciated your support.

i have used the same measures has shown in above by filltering the below measures

BS_Remarks_card =

CALCULATE(MAX('Sales Division Monthly Remarks (2)'[PL_Remarks]),'Sales Division Monthly Remarks (2)'[ContentType.Fields.Description]="BS_Primary and Measures")

PL_Remarks_card =

CALCULATE(MAX('Sales Division Monthly Remarks (2)'[PL_Remarks]),'Sales Division Monthly Remarks (2)'[ContentType.Fields.Description]="PL_Primary and Measures")

PA_Remarks_card =

CALCULATE(MAX('Sales Division Monthly Remarks (2)'[PL_Remarks]),'Sales Division Monthly Remarks (2)'[ContentType.Fields.Description]="Priority Activity")

I have created PL_Remarks custom column by using the below shown

Now single image is coming but its taking only PL_Remarks image for all above 3 measures. 

[uzuntasgokberk]

Hello @NadeemAhamed ,

I've posted a medium post about that. I think it helps for your case.  Check it out: https://medium.com/microsoft-power-bi/power-bi-with-sharepoint-images-and-reports-1d4db6fb61ce

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[NadeemAhamed]

@uzuntasgokberk  Thank you for your quick reply.

i have tried with the above the medium post. 

by using the sharepoint list i can bring the images into power bi but not able to identify which column image it is

when i am having 3 images for the admin(ex) division all 3 images are apperaing 

But i want to bring only PL_Remarks image into PL page that is not happening 

i have tried in Power query editor but not able to identify the url 

[uzuntasgokberk]

Hello @NadeemAhamed,

Find your image column in your power query and make sure there is a image in your sharepoint list. 

And, your data is sharepoint list. You need to get data sharepoint online list after use below the image method. I explained very detaily in my medium post.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[NadeemAhamed]

I have tried above steps.

In my case i have 3 images (PL_Remarks, BS_Remarks, PA_Remars) i have tried to create 3 custom column with the above screen syntax,

i have tried to bring only one image that is PL_Remarks but its showing all 3 images 

[uzuntasgokberk]

Hello @NadeemAhamed,

Could you please tried to create new column on dax(calculated column). I've tried on new column dax.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[NadeemAhamed]

Hi @uzuntasgokberk 

Yes i have tried to created new custom culumn by using the above steps.

when i expanded the some columns i have got some column contains the sharepoint list column name by using that i have created one measures and tried to filter by using the column name as shown below. 

BS_Remarks_card =

CALCULATE(MAX('Sales Division Monthly Remarks (2)'[PL_Remarks]),'Sales Division Monthly Remarks (2)'[ContentType.Fields.Description]="BS_Primary and Measures")

PL_Remarks_card =

CALCULATE(MAX('Sales Division Monthly Remarks (2)'[PL_Remarks]),'Sales Division Monthly Remarks (2)'[ContentType.Fields.Description]="PL_Primary and Measures")

PA_Remarks_card =

CALCULATE(MAX('Sales Division Monthly Remarks (2)'[PL_Remarks]),'Sales Division Monthly Remarks (2)'[ContentType.Fields.Description]="Priority Activity")

but i am getting only one result for all 3 measures. 

Could you please me out this issue. 

[uzuntasgokberk]

Hello @NadeemAhamed ,

You used power query new column. My example is new column(dax-calculated column example). Could you please create a new column(calculated column) and test it.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |