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...
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!

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!

LotteLaugesen's avatar
LotteLaugesen
Helper V
2 years ago

Perfect solution for me ðŸ˜Š  (downloaded the pbix)