Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following in a multi kpi box (where there is no colour by expression option)
I require 3 kpi's which is why i am using the multi kpi box and not the standard one
I need to colour the result red if <100 blue when >100
I have no idea if/how i can achieve this. can anyone assist?
Thank you
Num(sum({$<$(v.Date.IgnoreAll),[Year] = {"$(=max(Year))"}>}[GBP_Price]),'$(v.Format.Int.0dp)') /
Num(sum({$<$(v.Date.IgnoreAll),Month = {'Jan','Feb','Mar'},[Year] = {"$(=max(Year))"}>}([Budget in GBP])),'$(v.Format.Int.0dp)')
*100