Forum Discussion

lgreco's avatar
lgreco
New Member
6 years ago

Clustered Column chart conditional colors - two values (measures)

Hi experts, i have this clustered column chart and those configurations:

 

 

If i use only one value all the color conditional configurations were enabled, but with those values i only can assing a static color for each one. I only want to colored in red the negative values and green the positives.

One value is the porcentual variance of quantity of the current month:

divide(sum(HL), calculate(sum(HL), sameperiodlastyear(date)))

And the other is porcentual variance of quantity YTD vs YTD Last Year

 

thanks !

 

4 Replies