Forum Discussion
Helper VHow to align ICON centre justify on Matrix visual in Power BI
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
1 Reply
- Icey
Community Support
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.
