Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 On Schedule = green, past schedule = red, and Not included in metric = Black
2. In Metric column if the symbol = ✖️ and the schedule explanation = past schedule the I want the ✖️ to be in red or else blue
3. The column next to metric has condition to get a color bar ie Budget explanation = Under Budget and schedule explanation = past schedule then the column will be blue.
I have attached a screenshot of the excel sheet.
Is it possible to do that in Power BI?
Thanks in advance for your Help
Solved! Go to Solution.
@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 , 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
@amitchandak How to do conditional formatting on the unicodes
Multiple conditions are there for the unicodes.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |