Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

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 sus...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago

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