Forum Discussion
Align UNICODE icons
I have this measure (see below) that I am using to produce variance change in my table. It looks something like this (see below). I am having some trouble centring arrows in the middle. The usual suspects "Apply Settings to Series" - Value - Alignment did not work for me on this column but did for others, so I wonder if it is because of UNICODE?
% CHANGE =
VAR C = [MEASURE A]
VAR P = [MEASURE B]
VAR DIFF = P - C
VAR PERC = DIVIDE(DIFF, C, BLANK())
RETURN PERC
2 Replies
- AnonymousNot applicable
Hi stribor45 ,
Here are the steps you can follow:
If the icon was generated using the Dax function, you can do the following:
Measure = IF( MAX('Table'[Value]) >=4,UNICHAR(11014),UNICHAR(11015))Format – Specific column – Series: Select the field or measure you want to centre - apply it to the exact position you want to centre (header, total, values) .
Slignment – centering.
If the icon is a Style in a conditional format, you need to set the Icon layout to "Icon only" and then set it to be centred as in the above steps.
Refer to:
How to align ICON centre justify on Matrix visual ... - Microsoft Fabric Community
Solved: Icon with conditional formatting - Microsoft Fabric Community
If it doesn't meet your desired outcome, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
- stribor45
Post Prodigy
Anonymous
This is exactly what I have done and the header moves to the middle but the icons only a little bit. This is what I have...
This is the code that creates icons
ICONS_CHANGE = SWITCH (TRUE(), [% CHANGE] > 0.2, UNICHAR(9650), [% CHANGE] >= 0.1 && [% CHANGE] <= 0.2, UNICHAR(9654), [% CHANGE] < 0.1, UNICHAR(9660) )and conditions on this measure where I give them some colour are these