Forum Discussion
Add URL Conditional Formatting with ICON only
I have a power bi matrix that shows previous test results over the previous years I have it conditionally formatted to show the result with ICONS only. Is there a way to also include the Web URL...
bgierwi2 , Create icon and color measures. Use Icon measure in place of measure and use color(Using field value option) and url
example
/////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 for unichar icon - https://exceleratorbi.com.au/dax-unichar-function-power-bi/