Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Anu Radha]

?I have the requirement to show the image based on selection of either name or id in my report. I had created a column for this and it works fine. However the issue is when there is no slicer(the name and id are in slicer) selection then it shows the 1st image in the url list, meaning even if no selection is done an image appears by default.. I tried to create the column using if/selectedvalue/hasnovalue….none of them works for the column. And measure doesn’t work for the image url, the url being;

image url = (“http://mobile.sp…..net/…../crm/10…/”&(Rep[Rep ID])& “” & (Rep[Rep ID]) & “-ProfilePic.jpeg”)

I created a filter and used the filter for the image but just wants to know if there is any other solution . Because with the filter also if I don’t have any selection then there is a blank image but however if a selection is done in the slicer the image appears and when selection is unselected the same image appears until another selection is done

——————————
Anu Radha
98402454127
——————————

[Steven Magnuson]

You can use a measure instead of a column that will test to see if there is more than one selection (Note, you can replace the BLANK() with an image that says something like “Please make a selection” or some generic image):

image url = IF(COUNT(Rep[Rep ID]) > 1, BLANK(), "http://mobile.sp.....net/...../crm/10.../" & MIN(Rep[Rep ID]) & "-ProfilePic.jpeg"


——————————
Steven Magnuson
Business Intelligence Manager
——————————
——————————————-

[Anu Radha]

Thanks , the measure would work but I am not sure how to format it to image url, since it is a measure?? and I am using simple image to show the images

——————————
Anu Radha
98402454127
——————————
——————————————-

[Hubert Kobierzewski]

Hi Anu,

Perhaps you may add some sort of “no selection” record to your table with image URL. That record may appear in that table as a first one and it may do the trick.

Regards,

——————————
Hubert Kobierzewski
Board member
Data Community PL
——————————
——————————————-

[Anu Radha]

Thanks , I created a measure and used this as the filter in the simple image visuals??. That also has a glitch, when there is no selection it shows no image and image when selected the image appears but when we unselect the last selected rep name’s image still shows until another image shows.

I am using simple image as the visual which does not use a measure. I created a measure which gives me exactly what I need. But I don’t know which visual will work with measure and give a better quality for the picture appearance.

Please let me know if you have any other suggestions on this, will be highly appreciated.

——————————
Anu Radha
98402454127
——————————
——————————————-

[Amal BSF]

Hello ?, 
I have the same issue, and have a measure that gives me the exact url but the simple image would not take a measure as url. Did you find a solution to this issue? 
Thank you,

——————————
Amal BSF
——————————
——————————————-

[Krishna Nandan]

Hi 
If you want to create an Image URL, use SharePoint to create a URL for image and use the measure

——————————
Krishna Nandan
SME
Bangalore
——————————
——————————————-