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 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

  • Anonymous's avatar
    Anonymous
    Not 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's avatar
      stribor45
      Icon for Post Prodigy rankPost 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