Forum Discussion

refint650's avatar
refint650
Helper III
1 year ago
Solved

Bigger Conditional Icon size in matrix table column

Hello All   can we increase default conditional icon size in matrix table.? or  regular geneeral approach is to call & store image from external site and define image properties and assign image to...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi refint650 ,
    You can use SVG in conditonal formatting.
    Create a measure

    Icon = 
    SWITCH(
        TRUE(),
        SUM('Table'[Indicator]) >=0 && SUM('Table'[Indicator]) <=2 ,"data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 100 100'> <circle cx='50' cy='50' r='40' stroke='red' stroke-width='4' fill='red' /> </svg>",
        SUM('Table'[Indicator]) > 2 && SUM('Table'[Indicator]) <=3,"data&colon;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&colon;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>"
    )

    Change the mesaure data category as Image URL

    Apply to the conditonal formatting

    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