Dynamic Coloured Shapes

[ergocorp]

Hi there, Im trying to build a mock of a report, so please ignore some of the formatting.

I have manually coloured and set the directions of those arrows, but those are for the totals. The current and previous months cards may not follow that when you use the slicer to break it down by individual.

Is there any way I can have the arrows dynamically change direction and colour depending on the difference between the numbers above and below (to the left of each arrow)?

[VijayP · Accepted solution]

@ergocorp 

With IF condition you can create a measure

if( this value < that value ,UNICHAR(123456) ,Unichar(132345)) just example

all unichar values available in this link https://www.vertex42.com/ExcelTips/unicode-symbols.html

you can use a card and use Title and in the title you can add this measure

[ergocorp]

Thanks, 

You've given me a couple of questions though.

1. Conditional Measures. I think that would be a create measure, can i just google how to set that up?

2. Once i have done that, which visualisation would I use to display it?

3. I've never used unichar() is that a DAX expression?

Thanks

[VijayP · Accepted solution]

@ergocorp 

With IF condition you can create a measure

if( this value < that value ,UNICHAR(123456) ,Unichar(132345)) just example

all unichar values available in this link https://www.vertex42.com/ExcelTips/unicode-symbols.html

you can use a card and use Title and in the title you can add this measure

[ergocorp]

Excellent, I have that working. The next query is around colour. Can I add that in do you know?

[VijayP · Accepted solution]

@ergocorp  you have different coloured shapes check them! and share your Kudos and if it is your soltuion Mark this as solution!

[ergocorp]

Thanks!

[VijayP]

@ergocorp 

You need to create a conditional measure with different colour and then use unichar() values to create those arrows instead of manual shapes!