Forum Discussion
Dynamic Coloured Shapes
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)?
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
6 Replies
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
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
Excellent, I have that working. The next query is around colour. Can I add that in do you know?
