Bar chart, always 20% different color

[Applicable88]

Hello,

I have a typical measure and a date dimension in a bar chart. Is ist possible to always color 20% of the bar chart dynamically? No matter how high the value, 20% of the bar chart is e.g. orange and the rest is blue.

Thank you very much in advance.

Best

[DataVitalizer]

Hi @Applicable88 

I would create two extra measures as below, lets call the measure that has the whole value Measure1.

Measure2= 20% of Measure1

Measure3=Measure1 - Measure2

Then drag Measure2, Measure3 and date into a stacked histogram visual.

Did it work ? 👌 Mark it as a solution to help spreading knowledge  👉A kudos would be appreciated

[Applicable88]

@DataVitalizer, when its not possible not implement it into "one" bar, will the can the order be fixed, like 20% always bottom and 80% always top?

[DataVitalizer · Accepted solution]

@Applicable88 in the field value of your visual drag 80% first then 20%

Did it work ?  Mark it as a solution to help spreading knowledge  A kudos would be appreciated