Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
M4rcoCelmi
Contributor
Contributor

Color Condicional Valor Max y Min

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.

ColorMinmax.JPG 

 

Labels (2)
1 Solution

Accepted Solutions
M4rcoCelmi
Contributor
Contributor
Author

Thanks I was able to solve the problem
Resuelto Color.JPG

View solution in original post

2 Replies
Gui_Approbato
Partner - Creator III
Partner - Creator III

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()
))

M4rcoCelmi
Contributor
Contributor
Author

Thanks I was able to solve the problem
Resuelto Color.JPG