Forum Discussion

atasgao's avatar
atasgao
Helper II
5 years ago
Solved

Conditional formatting on multiple text column

Hi Everyone,  I am creating a matrix visual in Power BI. Where I have to do the conditional formating by text.  So, 1. Schedule Explanationcolumn the fields text should be with respective colore O...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

atasgao , Based on what I got so far.  You can create unichar icon and use conditional formatting using measure. Example of both. Please note you have to get the correct unichar from the list and condition based on your requirement

 

////Arrow
Arrow =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, UNICHAR(9650),
_change = 0, UNICHAR(9654),
_change < 0, UNICHAR(9660)
)


/////Arrow Color
Arrow color =
var _change =[Net Sales YTD]-[Net Sales LYTD]
return
SWITCH (
TRUE(),
_change > 0, "green",
_change = 0, "blue",
_change < 0, "red"
)

 

refer

UNICHAR - Tool for Custom Icon Formatting: https://www.youtube.com/watch?v=veCtfP8IhbI&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=50

 

list of unichar

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

 

Also, check if needed

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692

  • atasgao's avatar
    atasgao
    Helper II
    5 years ago

    amitchandak How to do conditional formatting on the unicodes

     

    Multiple conditions are there for the unicodes. 

     

    Thanks!