Color formatting of every bar

[Anonymous]

Hi guy's

I have a Bar chart Visualization like this,

I have a requirement like every bar till 13 values it'll showing yellow after 13 white, Is it possible for writing Dax of this issue.  

I want to like this.

 

regards,
Naveen

[VasTg · Accepted solution]

@Anonymous 

I would split the measure into two and use them stacked bar chart. This way you could change the color for individual measure.

Measure 1 = IF(SUM(Sales[Revenue])>13,SUM(Sales[Revenue])-13,0)

Measure 2 = IF(SUM(Sales[Revenue])>13,13,SUM(Sales[Revenue]))

Note that the sorting order might differ but I guess you could use Sort By column option to sort it based on your need.

If it helps, Please mark this answer as a solutions.

Kudos are good too.