Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I have created a conditional formatting on a matrix visual based on below rule
However, I want the ICON to appear in centre of each column and its not appearing in centre (it appears on the left side) I tried the COnditional formatting property of the matrix visual to align it to centre justfy but its not helping either
When I change the ICON LAYOUT property it then changes to righ of data, there is no option to sya Centre justify it
Hi @smjzahid ,
Based on my test, if we want to center the icon, the only way is to set 'Icon Only' under the advanced options for conditional formatting and set the alignment to center in the field formatting. For details, please check: Solved: Icon with conditional formatting - Microsoft Power BI Community.
But this doesn't meet your requirements, so we can try to use UNICHAR function to return the Unicode character referenced by the numeric value. For unicode numbers, please check: Huge List of Unicode Character Symbols (vertex42.com).
Because there isn't this icon in the above list, we choose to use these ones.
⚠ | ❕ | ❗ |
9888 | 10069 | 10071 |
Measure =
VAR SUM_ =
SUM ( 'Table'[Sales] )
RETURN
IF ( ISBLANK ( SUM_ ), UNICHAR ( 10071 ), SUM_ )
For details, please check the attachment.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.