Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need a conditional to show the Minimum value in Red and Maximum in Green, I have 2 dimensions Week (Measure) and Date on the X(Dimension) axis.
Thanks I was able to solve the problem
Hello,
Add your dimensions in the Aggr function. Try this:
if(
Sum(Value)=Max(Total Aggr(Sum(Value), Dimension)),
green(),
if(
Sum(Value)=Min(Total Aggr(Sum(Value), Dimension)),
red(),
blue()
))
Thanks I was able to solve the problem