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?
Solved! Go to 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.
It depends on which week you select. If you pick one where the WoW change is > 0 it will be green:
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
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.
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
I've been able to get to this... 🙂
Bit more cleanup required... however it's getting there...
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
178 | |
67 | |
65 | |
57 | |
55 |
User | Count |
---|---|
184 | |
103 | |
89 | |
75 | |
72 |