Picture changes on the percentage value of a measure

[Anonymous]

Hi All,

I will be thankful in advance for someone 's experience if they can share for below scenario:

I need to create a visual in my report showing one picture out of 3 pictures but picture is selected on the basis of percentage value of a specific measure.

For example ( Like conditional formatting in excel but not formatting but displaying picture )

• if percentage of a measure X is between 0% - 60% then show RECTANGLE picture.
• If percentage of a measure X is greater than 60% but less than equal to 80% then TRIANGLE picture
• If percentage of a measure X is greater than 80% but less than or equal to 100% then SQUARE picture.

I am surprised not to find any help anywhere as all videos and solutions are talking about URL option. How can I fit URL option in this scenario and if any help or link someone can share, will be ideal.

Hope I explained well and above scenario is simplied version of what I am facing. But if you feel you need some more explanation please feel free to ask.

Thanks again for your much needed urgent help. 

Regards

[Greg_Deckler]

Sure, you can set a measure to be a Data Category of Image URL and then you just need to return the correct Image URL based on the calculation. Or you can return an SVG image. Or just use the built-in conditional formatting icons.

[Anonymous]

Thanks very much for such a prompt reply.

Can you please elaborate a bit on 

set a measure to be a Data Category of Image URL and then you just need to return the correct Image URL based on the calculation.

I understand data category of Image URL but writing DAX to bring correct URL is causing problem

I have written DAX as below to display RECTANGLE or TRIANGLE -- ignored SQUARE, just so it runs atleast

IconFlag = SWITCH(True()
,CALCULATE(DISTINCT(tbl_Icons[IconURL])
,FILTER(tbl_Icons
,CONTAINSROW(
{IF( [X measure] <= 0.60,"RectangleURL","TriangleURL")}
,tbl_Icons[IconURL]
)))=1
,1,0)

where tbl_Icons contain RectangleURL, TriangleURL and SquareURL.

I followed instructions from 

https://visualbi.com/blogs/microsoft/powerbi/dynamically-display-images-power-bi/ 

Can you please help writing DAX to dynamically select image on the basis of measure value.

regards

[v-lid-msft · Accepted solution]

Hi @Anonymous ,

We can try to use the following measure to meet your requirement (we use the url of forum's default avatars as an example)

Icon = 
IF (
    [X measure] < 0.6,
    "/t5/image/serverpage/avatar-name/skyscraper/avatar-theme/candy/avatar-collection/architecture/avatar-display-size/message/version/2?xdesc=1.0",
    IF (
        [X measure] < 0.8,
        "/t5/image/serverpage/avatar-name/castle/avatar-theme/candy/avatar-collection/architecture/avatar-display-size/message/version/2?xdesc=1.0",
        "/t5/image/serverpage/avatar-name/modern/avatar-theme/candy/avatar-collection/architecture/avatar-display-size/message/version/2?xdesc=1.0"
    )
)

If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that we have shared？

Best regards,