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 conditional formatting with Icons only conditional formatting?
If I change the current conditional formatting to show both the icon and result: the Web URL works. But I want to keep it as Icon only. Alternatively if I could toggle between the two views (Icon only & Icon with result), that would be an improvement over what I have (but the preference would be icons only).
2 Replies
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/
I was able to get it to work!
Using the first measure you listed, that became my value.
Then the second measure was used in the conditional formatting for color.
As you described, and everything makes sense
Did have one complication:
I have some entries where a cell has multiple entries (Multiple tests in the same year). In my previous visual each value was 1,2, or 3 and had conditional monitoring that set the icons. So the value was sorted to max, and it would only show the worst result (3 was the worst result, 2 was next, and 1 was pass).
Now with the UNICHAR described above, if there are multiple entires nothing is shown.
Is there a way to control how multiple entires are shown in a matrix?
