FORMAT icon set for use in a data card

[dgwilson]

I'm building my own KPI indicator. The last element to get working is an indicator icon.

I have a DAX Measure that turens 0, 1, 2 (Up, Down, Neutral). All I need out of that is the ICON.

Fundamentally this does the trick.

    SWITCH (
            TRUE(),
            theIndicator = 1, "ColoredArrowUp",
            theIndicator = 0, "ColoredArrowRight",
            theIndicator = 2, "ColoredArrowDown"
            )

Is it possible to now use the FORMAT DAX command deliver the ICON result? It doesn't have Custom Formatting available.

I can deliver the ICON via a Table - but that has a column header and row values - so that's super ugly.

How would you deliver the ICON?

[jdbuchanan71]

It depends on which week you select.  If you pick one where the WoW change is > 0 it will be green:

[jdbuchanan71]

The measure [Icon] goes on a card and the measure [Icon Format] is used in the conditonal formatting.  In a card the formatting is applied to the callout value.

I have also attached a sample file for you to look at.

[ALEX2011ALfer_]

I made some change. if value > 1 then it should be green etc. please look at the file it just give me Red while it should give me Green becuse the value is > 1

check the file please

 Format icon 

[jdbuchanan71 · Accepted solution]

Hello @dgwilson 

You could look at the UNICHAR() function to return an icon to a card.  It would be something like this where [Parameter Value] is your measure that returns the result.

Icon = 
VAR theIndicator = [Parameter Value]
RETURN
   SWITCH (
            TRUE(),
            theIndicator = 1, UNICHAR(9650),
            theIndicator = 0, UNICHAR(9654),
            theIndicator = 2, UNICHAR(9660)
            )

Then you can make a measure that does the conditional fomatting on the data label as well.

Icon Format = 
VAR theIndicator = [Parameter Value]
RETURN
   SWITCH (
            TRUE(),
            theIndicator = 1, "Green",
            theIndicator = 0, "Yellow",
            theIndicator = 2, "Red"
            )

When you combine the two together in a card you will be close I think.

[ALEX2011ALfer_]

i did not understand the solution. can you explain where i should use the measure in a card or what? it will not let me

[dgwilson]

I've been able to get to this...  🙂

Bit more cleanup required... however it's getting there...

[dgwilson]

That is a very nice solution. Thank you.

I have a few more measures that I'd really like just to support the implementation, I can hopefully workaround this with groups and/or naming of the measures.

Thank you.