Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[William Skelley]

Hello:

I am looking for assitance in writing the proper DAX to show both the percent change and then a down or up arrow based on it’s a positive or negative result.

When I just use one half of the measure it works, but not for me when I try to cover both bases.

This is what I have, that isn’t working.

% VAR to LY Sales =
SWITCH (

[% VAR-LY],

[% VAR-LY]<0, “?”, “”) & ” ” & FORMAT([% VAR-LY], “Percent”)

[% VAR-LY]<0, “?”, “”) & ” ” & FORMAT([% VAR-LY], “Percent”),, BLANK())

I am fine with getting jsut symbols but I’d like both symbols and numbers of the percent change(in this case).

This, below, works fine for symbols. I read it in a blog.

Variance just Symbols to Sales LY =

VAR Down = UNICHAR(11167)

VAR Up = UNICHAR(11165)

VAR UpLots = UP & Up

VAR Side = UNICHAR(11166)

Return

SWITCH(True(),

[% VAR-LY] < 0, Down,

[% VAR-LY] > 0.15, Up Plenty,

[% VAR-LY] > 0.01,Up,

Side

)

I have bolded the measure I could use help on.

Thank you,

Bill S.

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————

[Vishesh Jain]

Hi ,

Please can you try replacing the actual symbol in your measure with the UNICHAR code.

The symbol should work since it is text, but ideally I’ve seen UNICHAR codes being used in DAX.

Even the sample code that you shared, contains UNICHAR characters, defined in variables.
You can probably implement a similar approach.

Hope this helps.

Thank you,
?

——————————
Vishesh Jain
Owner
VR Construction
——————————
——————————————-

[William Skelley]

Hi Vishesh:

Thank you for replying and giving me this suggestion! I remember you helped me out early on with a balance of year measure too.

Have a great day and it’s great you help so many!

Best regards,

Bill

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-

[Vishesh Jain]

Hi William,

Glad to be of assistance.

I had been out of office due to the pandemic for nearly 2 months and its good to be finally be back!

Hope you solve your issue.

Thank you,

——————————
Vishesh Jain
Owner
VR Construction
——————————
——————————————-

[Krishna Nandan]

Hi,
You can use KPI ticker. Search on get more visualization. Its very easy to use. https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380946

——————————
Krishna Nandan
SME
Bangalore
——————————
——————————————-

[William Skelley]

Hi Krishna:

Thank you for replying too! I just downloaded the KPI ticker visual and will check it out. I really appreciate that. Best regards,

Bill

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-

[John Thomas]

Hi Bill!

Check this out:

https://youtu.be/zHzSBNES6jE

They even have a sample file…

Cheers!

——————————
John Thomas
Huntersville NC
——————————
——————————————-

[William Skelley]

Hi John:

Thanks very much for sharing that. I just watched it. So it makes sense. I did not not see the example file though. Maybe I’m missing where the link is.

Great stuff!

Thanks again.

Bill

——————————
William Skelley
01106
Longmeadow MA
8602807221
——————————
——————————————-