Forum Discussion
Color Coordinating a stacked column chart based on a third field
Hi RyanStewart ,
I created some data:
As far as I know, the Conditional Color Formatting option works when you don't have legend fields enabled and add multiple fields to the Chart Values field, if you have legend fields enabled, you can only manually select each Legend in Column to give the corresponding color.
Power BI stacked column chart can only place one field in the legend, you can try to create a create column to merge the two columns together.
Create calculated column.
Column =
[Part Type]&"-"&[Job.oper]
You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I appreciate the suggestion to make a combined column of Part Type and Job, but I don't think it will give me what I'm looking for. I still need to enter that combined column into the "Legend" field to get the separation, but then I lose the ability to change the colors based on part type.
I think you're right that I need to submit a ticket to Microsoft to make this feature change, because it seems like at this point Power BI is unable to do what I'm looking for.
Thank you,
Ryan Stewart