Clustered Column chart conditional colors - two values (measures)

[lgreco]

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 !

[amitchandak]

@lgreco , conditional formatting is not allowed when using multiple measures or legends.

You can vote for an idea. There a few of them

https://ideas.powerbi.com/ideas/search-ideas/?q=legend%20conditional%20formatting

[lgreco]

ok, thanks @amitchandak ! i'm going to do that.

Regards,

[MFelix]

Hi @lgreco ,

This is not possible on this type of chart, I would suggest that you try out the custom visual below:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000183?tab=Overview

[lgreco]

Thanks @MFelix ! that custom visual is paid 😞 and i need only that customization.

Regards,