Conditional Formatting Using Icons In Power BI - SVG NOT the build in icons

[Rygaard]

So your PR asked me to use corporate color palette for our power bi Embeded RED/Yellow/Green for a visaual representation of our items in stock.

I have tried a number of aproaches that i could not get to work

1) 

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

No matter what i do i could not get it to show the new colours.

2)

https://www.youtube.com/watch?v=hxzeA6PDU4Y&t=91s

the nested IF did NOT work for me

Here is what did work

Icon Set Measure 3 = 
Var svgStart = "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' x='0px' y='0px' width='100' height='100' viewBox='0 0 100 100'>"
var svgFinish = "</svg>"
// above is start and finish that is the same for ALL SVG graphics. they are in a VAR ONLY to make the SWITCH more readable 
var res= SWITCH (
    TRUE (),
         [##Sum_Stock] > SUM('RGS Item_Stock_sums'[IS_Stock_Tolerance]), svgStart & "<circle cx='50' cy='50' r='40'  stroke='#5D6E5A' stroke-width='4' fill='#5D6E5A' />" & svgFinish,
         [##Sum_Stock] > SUM('RGS Item_Stock_sums'[IS_Stock_Tolerance])/2, svgStart & "<circle cx='50' cy='50' r='40' stroke='#C49949' stroke-width='4' fill='#C49949' />"& svgFinish,
                                                                           svgStart &"<circle cx='50' cy='50' r='40' stroke='#814539' stroke-width='4' fill='#814539' />" & svgFinish
    
)
return res

To get this to work you need to do 3 things after makeing your new meassurement

1 ) set the datatype to Text

2) set the data category to Image URL

3) after you added it to your matrix, remember this is an image, so search for image size and resize it to 30 by 30

Now you can drag it into a matrix and use it like any other meassure.

you can also do other shapes.... you can even draw your own shapes in SWG and use that