Change color of Bar as per month

[Anonymous]

I have a graph like this with a simple measure of Sum(Sales).

Black color reamins same throughout. After a certain month i want the color to change from yellow to blue.

Two different measures are there represented by black and yellow. I want to alter the color of the measure represented by yellow,For example till august i want in yellow,after that blue.

How can i do that?

[mussaenda]

Hi @Anonymous,

if you have a month number, representing each month name, then its possible.

Using Conditional formatting

[Anonymous]

Yes i have it, but the thing is conditional formatting dosent come if we have multiple measures, it comes only if we have a single measure in my graph

[Anonymous]

You can use the newly introduced feature by PowerBI, which is "Conditional Formatting" on the Data Color tab.

Check attached.

[Anonymous]

hi @Anonymous 

i tried @Anonymous  query, but we not able to see conditional formating button.

here, i am using clustred column chart visualization.

regards,

Naveen

[Anonymous]

yes when you use multiple measures that option wont come

[mussaenda]

I tested this. And yes, you are right. Conditional formatting is not available when you have more than one measures.

But if one measure only, it works.

[Anonymous]

hi @Anonymous ,

then, what's the solution for your query?

regards,

Naveen

[Anonymous]

I dont know how to do that is the reason i posted it here bro 🙂

[Anonymous]

hi @Anonymous 

Instead of measures i am using columns only, after that also Conditional Formatting not showing.