Forum Discussion
Dynamically display image based on measure - DAX help!!!
I have a dashboard which shows salesperson productivity. I created a measure that compares "Current Rank" with Last Month "Rank" to show movement. If they gain a position the number is positive, no change = 0 and is neutral and lastly if the lose position how many they dropped (negative number).
I would like to translate this to an icon set which shows an increase as an "arrow up", decrease as an "arrow down" and no change as a neurtal icon.
I need some help writing a DAX statement that is as simple as:
If measure is "0" then icon, or if measure is >0 then "arrow up", or if measure is <0 "arrow down"
Appreciate any help that you provide.
You want Anonymous's Arrow Rating Quick Measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Arrow-Rating/m-p/231558
4 Replies
You want Anonymous's Arrow Rating Quick Measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Arrow-Rating/m-p/231558
Looks like a great solution. However, my current and last month rank is not a calc. Thoughts?
Hard to say without knowing what your data looks like but if it just some number in a table, just use something like:
Measure = IF(MAX([Column])<0, <unichar down arrow>, <unichar up arrow>)
Again, tough to say without knowing what your data looks like.