Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix - conditional formatting - Icon

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?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    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!

3 Replies