Conditional formatting on a stacked bar chart with 2 measures

[Anonymous]

Hi there, 

Can anyone help me with creating a bar chart with conditional formatting? I have it as a 100% stacked bar chart visual (client requirement) but as soon as I put the second measure on, conditional formatting disappears. The second measure is equal to 1 - the first measure and gives me the grey bar.

It may be that there is a different solution to this which could help me. My only thoughts to date is to overlay one visual with another (the latter being the 100% grey bar), but I'd prefer a simpler solution as this has to roll out to a lot of visuals.

I have a feeling I've missed something obvious.... 

Thanks!

[v-piga-msft]

Hi @Anonymous ,

I'm still a little confused about your sceanrio.

It seems that there is no conditional formatting for 100% stacked bar chart.

I will need more details to know your scenario.

If it is convenient, could you share your dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Cherry

[Anonymous]

Hi @v-piga-msft 

Please see link below. Top bar chart has two measures, middle one has one measure. When you add a second measure to the middle one, the conditional formatting disappears (on formatting/data colours/) 

Needless to say the middle bar chart is not useful - I want the top one with conditional formatting! 

My solution is the bottom one, but that requires two visuals overlaid.

https://oxfordpowerbi-my.sharepoint.com/:u:/g/personal/angus_oxfordpowerbi_co_uk/EWCrT6J1dTVNjgi8h2p...

[Anonymous]

Hi @v-piga-msft 

I was wondering if you'd had any further thoughts on this? Is my solution of two overlaid bar charts the only possible approach?

Thanks!