Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to use the new indicator feature. Is it not possible to use the indicators similar to background color?
In this example I want the arrows to be relative to sum(PrevYear) of that office. But it seems that this feature takes the total sum of PrevYear and applies it to all indicators. So what I want is that only C and D show green arrow, A and B should be red.
To my knowledge, it is indeed not possible to calculate indicator limits by row level.
Hopefully that functionallity will be added one day.
You could use following guide to achieve what you want: Conditional Performance Indicators
Hi, for anyone still bothered by this, my work around was to use dual and create a basic flag.
Anything above 1 or below 1.
This allows you to either have it in a separate column or next to the value as intended.
(In my example I only want to indicate things going up, but you can adjust/customize this to show how you want)
You need to wrap num formatting to master measures in order for the text to be shown as you want.
The example below is calling master measures in the expression console. Should work with variables as well.
Expression: if(Yesterday>[Same Day Last Year],dual(num(Yesterday,'€#.##0') ,1), dual(num(Yesterday,'€#.##0'),-1))
Yesterday vs Same Day Last Year (indicator only option)
Wednesday 12 Oct 2022 (dynamic date label to represent actual yesterday)
Indicator with values
Table (final results)