Can you use a VAR to set a color of unichar circle? Matrix Row (can't use conditional formatting)

[Anonymous]

I am using a matrix so I cannot use conditional formatting (terrible functionality).  I need to show green , yellow or red for a status in the Row header and there are not any available unichars for this so I was curious if I could assign a color with a VAR or some work around so that is I have a status of On Track - I see a Green Circle, etc.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You can use the conditional formatting in Matrix:

1. Refer to the format panel:

https://chandoo.org/wp/conditionally-format-visuals-in-power-bi/ 

2. Use the measure: 

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-percentage-of-multiple-values/m-p/720970#M347921 

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-Matrix-Visual/m-p/876777 

[Sergiy]

You can use an image for this purpose. This image has to be kept in a table column which Data Category has to be specified as "Image URL"

Try it:

"data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB3aWR0aD0iMTZweCIgaGVpZ2h0PSIxNnB4IiB2aWV3Qm94PSIwIDAgMTYgMTYiIHZlcnNpb249IjEuMSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiB4bWxuczp4bGluaz0iaHR0cDovL3d3dy53My5vcmcvMTk5OS94bGluayI+CiAgICA8IS0tIEdlbmVyYXRvcjogU2tldGNoIDUzLjEgKDcyNjMxKSAtIGh0dHBzOi8vc2tldGNoYXBwLmNvbSAtLT4KICAgIDx0aXRsZT5pY19jb25uZWN0b3JzX2ppcmE8L3RpdGxlPgogICAgPGRlc2M+Q3JlYXRlZCB3aXRoIFNrZXRjaC48L2Rlc2M+CiAgICA8ZGVmcz4KICAgICAgICA8bGluZWFyR3JhZGllbnQgeDE9IjY3LjY4MDAxNDglIiB5MT0iNDAuMzI3Njk1NiUiIHgyPSI0MC44MjA4MTglIiB5Mj0iODEuNjU5NjE5NSUiIGlkPSJsaW5lYXJHcmFkaWVudC0xIj4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzAwNTJDQyIgb2Zmc2V0PSIxOCUiPjwvc3RvcD4KICAgICAgICAgICAgPHN0b3Agc3RvcC1jb2xvcj0iIzI2ODRGRiIgb2Zmc2V0PSIxMDAlIj48L3N0b3A+CiAgICAgICAgPC9saW5lYXJHcmFkaWVudD4KICAgICAgICA8bGluZWFyR3JhZGllbnQgeDE9IjMyLjY1NTk4NTElIiB5MT0iNTkuMTY2NDQ2OCUiIHgyPSI1OS4zNDMwMzAyJSIgeTI9IjE3Ljk4OTk3NjMlIiBpZD0ibGluZWFyR3JhZGllbnQtMiI+CiAgICAgICAgICAgIDxzdG9wIHN0b3AtY29sb3I9IiMwMDUyQ0MiIG9mZnNldD0iMTglIj48L3N0b3A+CiAgICAgICAgICAgIDxzdG9wIHN0b3AtY29sb3I9IiMyNjg0RkYiIG9mZnNldD0iMTAwJSI+PC9zdG9wPgogICAgICAgIDwvbGluZWFyR3JhZGllbnQ+CiAgICA8L2RlZnM+CiAgICA8ZyBpZD0iU3ltYm9scyIgc3Ryb2tlPSJub25lIiBzdHJva2Utd2lkdGg9IjEiIGZpbGw9Im5vbmUiIGZpbGwtcnVsZT0iZXZlbm9kZCI+CiAgICAgICAgPGcgaWQ9ImEtLy1pY29uLS8taGVhZGVyLS8tY29ubmVjdGlvbnMtLy1qaXJhLXNvZnR3YXJlIj4KICAgICAgICAgICAgPGcgaWQ9ImljLWppcmEtc29mdHdhcmUtYWN0aXZlIj4KICAgICAgICAgICAgICAgIDxwYXRoIGQ9Ik0xNS4yNDIxMDUzLDcuNTI4NDIxMDUgTDguMzc4OTQ3MzcsMC42NjUyNjMxNTggTDcuNzEzNjg0MjEsMCBMNy43MTM2ODQyMSwwIEwyLjU0NzM2ODQyLDUuMTY2MzE1NzkgTDIuNTQ3MzY4NDIsNS4xNjYzMTU3OSBMMC4xODUyNjMxNTgsNy41Mjg0MjEwNSBDLTAuMDYxMDEzMzcxLDcuNzc1MDA0MjUgLTAuMDYxMDEzMzcxLDguMTc0NDY5NDMgMC4xODUyNjMxNTgsOC40MjEwNTI2MyBMNC45MDUyNjMxNiwxMy4xNDEwNTI2IEw3LjcxMzY4NDIxLDE1Ljk0OTQ3MzcgTDEyLjg4LDEwLjc4MzE1NzkgTDEyLjk2LDEwLjcwMzE1NzkgTDE1LjI0MjEwNTMsOC40MjEwNTI2MyBDMTUuNDg4MzgxOCw4LjE3NDQ2OTQzIDE1LjQ4ODM4MTgsNy43NzUwMDQyNSAxNS4yNDIxMDUzLDcuNTI4NDIxMDUgWiBNNy43MTM2ODQyMSwxMC4zMzI2MzE2IEw1LjM1NTc4OTQ3LDcuOTc0NzM2ODQgTDcuNzEzNjg0MjEsNS42MTY4NDIxMSBMMTAuMDcxNTc4OSw3Ljk3NDczNjg0IEw3LjcxMzY4NDIxLDEwLjMzMjYzMTYgWiIgaWQ9IlNoYXBlIiBmaWxsPSIjMjY4NEZGIiBmaWxsLXJ1bGU9Im5vbnplcm8iPjwvcGF0aD4KICAgICAgICAgICAgICAgIDxwYXRoIGQ9Ik03LjcxMzY4NDIxLDUuNjE2ODQyMTEgQzYuMTY5OTExMjEsNC4wNzI4ODY3MyA2LjE2MjM4NzQxLDEuNTcyMTY0MDUgNy42OTY4NDIxMSwwLjAxODk0NzM2ODQgTDIuNTM2ODQyMTEsNS4xNzY4NDIxMSBMNS4zNDUyNjMxNiw3Ljk4NTI2MzE2IEw3LjcxMzY4NDIxLDUuNjE2ODQyMTEgWiIgaWQ9IlNoYXBlIiBmaWxsPSJ1cmwoI2xpbmVhckdyYWRpZW50LTEpIiBmaWxsLXJ1bGU9Im5vbnplcm8iPjwvcGF0aD4KICAgICAgICAgICAgICAgIDxwYXRoIGQ9Ik0xMC4wNzc4OTQ3LDcuOTY4NDIxMDUgTDcuNzEzNjg0MjEsMTAuMzMyNjMxNiBDOC40NTg4MTMyNSwxMS4wNzczMTc1IDguODc3NDU5NjYsMTIuMDg3NTk0MyA4Ljg3NzQ1OTY2LDEzLjE0MTA1MjYgQzguODc3NDU5NjYsMTQuMTk0NTEwOSA4LjQ1ODgxMzI1LDE1LjIwNDc4NzggNy43MTM2ODQyMSwxNS45NDk0NzM3IEw3LjcxMzY4NDIxLDE1Ljk0OTQ3MzcgTDEyLjg4NjMxNTgsMTAuNzc2ODQyMSBMMTAuMDc3ODk0Nyw3Ljk2ODQyMTA1IFoiIGlkPSJTaGFwZSIgZmlsbD0idXJsKCNsaW5lYXJHcmFkaWVudC0yKSIgZmlsbC1ydWxlPSJub256ZXJvIj48L3BhdGg+CiAgICAgICAgICAgIDwvZz4KICAgICAgICA8L2c+CiAgICA8L2c+Cjwvc3ZnPg=="