Dashboard design Question

[arusanah]

GM Friends ,  Is there a way we can show images based on measure value in #1 KPI or text object.

if ( current year sale > prev year sale ,'arrow up' , if( current year sale < prev year sale , 'arrow down ','resize arrow'))

I can easily do it with Simple KPI extension , using :icon" , but client is not ready to use extension for security, so I need to find work around for it .

As you any help is highly Appreciated!

[balabhaskarqlik · Accepted solution]

Hey, check this link:

Conditional Performance Indicators in Tables using HTML Unicode Chr() Values

Try this expression:

=if ( [current year sale] > [prev year sale], chr(9650) , if( [current year sale] < [prev year sale] , chr(9660), chr(9668)&chr(9658) ))

[arusanah]

Thank You Bala !!