Forum Discussion
planc7
1 year agoHelper I
Conditional Formatting: adding icon with field value option
Hi everyone, I'm struggling to add custom icon in matrix with field value option. I have created this measure expecting the icon appearing in the blue column but nothing happened. What am...
- Anonymous1 year ago
Hi planc7 ,
Thanks for amitchandak reply.
After making sure that your filters are not incorrect, you can check to see if the Data Category of your measure is set to the Image URL format, so that the SVG format you are referencing will be recognized correctly. The following pbix file is an example of using the SVG format.Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous
1 year agoNot applicable
Hi planc7 ,
You can try this
Icon 2 =
SWITCH(
TRUE(),
SUM('Table'[Indicator]) >=0 && SUM('Table'[Indicator]) <=2 ,"data:image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 20 20' version='1.1' > <path d='M8.469-1.156h2.25v29.813h-2.25v-29.813z'></path></svg>",
SUM('Table'[Indicator]) > 2 && SUM('Table'[Indicator]) <=3,"data:image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='30' stroke='yellow' stroke-width='4' fill='yellow' /> </svg>",
SUM('Table'[Indicator]) > 3,"data:image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='20' stroke='green' stroke-width='4' fill='green' /> </svg>"
)
Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly