Matrix - conditional formatting - Icon

[Anonymous]

Hi Community,

I want to get the following formatting in my matrix analogous to my table.

as an example my table

here my matrix without the conditional formatting

this is what it should look like

Is such a thing possible with a matrix and if so how can it be?

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

You may create a measure using UNICHAR shown as below:

Measure = SWITCH(SELECTEDVALUE('Table'[value]),
1,UNICHAR(128309),
UNICHAR(128308))

Or you could create a KPI column first to get a circle icon:

KPI column = UNICHAR(11044)

Then refer to the video to finish the format settings:

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[LotteLaugesen]

Perfect solution for me 😊  (downloaded the pbix)

[amitchandak]

@Anonymous , not very clear. Refer if this can help. Look how a measure is created below(in blog)

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