100% Stacked Bar Chart Conditional Formatting

[pureprogression]

Dear Community,

I am trying to develop a stacking plan for office buildings in Power BI desktop. I am using a 100% Stacked Bar Chart to achieve the stacking plan. The Y axis shows the floors of the office building, the X axis shows the % of space a tenant uses from the 100% of the floor space of the office building (e.g. floor 7 has a total of 1,000 sqm, tenant A uses 100 sqm, % shown is 10% for tenant A etc.)

My challenge is that I would like to apply a conditional formatting to each tenant based on their contract expiry date, however, the visual is based on SQM of tenants, not their contract expiry date. I would like to keep the visual representing SQM proportions, but I would like to apply a conditional formatting based on contract expiry dates.

Do you think it is feasible to do this in Power BI desktop (if yes, how?) or would a custom development be required to deliver this visual?

Thank you for the help in advance!

Best regards,

Pureprogression

[amitchandak · Accepted solution]

@pureprogression , Conditional formatting does not work with visuals having legend. so I doubt you can do that in this case

[pureprogression]

Thank you Amit. It seems in this case I have to settle for the formatting originally given by Power BI and apply two visuals side-by-side for comparison, one with the SQM and one with the expiry date.