Forum Discussion
Stacked column chart conditional formatting power bi
Hi,
I'm using a stacked column chart to show my data which has two important variables (a unique name and a grouping, where several items can be within one group). I can show each item's unique name however I cannot use conditional formatting to show what group each of them are in. I just get random colours assigned to each item and then it seems like I have to manually colour the items to show they belong to a certain group. I would really like to avoid this as (i) it will take a long time to manually colour each item and (ii) there is a chance I may make an error and (iii) I'm going to have to check this often when new items are updated on the graph.
Any suggestions?? Do you know when Power BI is going to enable conditional formatted for stacked column charts?
Thanks!
Consider using a Deneb visual instead where you can implement your own color management
Hi Sweden_25 ,
You can create your required conditional formatting by adding a stacked column chart with the following set up:
Your item is consistently colored depending on which grouping they belong to. It turns out that without doing any special configuration, Power BI's native function supports coloring like above. Does this address your issue properly?
I have attached an example pbix file for your reference.
Best regards,
8 Replies
Consider using a Deneb visual instead where you can implement your own color management
Hi Sweden_25 ,
You can create your required conditional formatting by adding a stacked column chart with the following set up:
Your item is consistently colored depending on which grouping they belong to. It turns out that without doing any special configuration, Power BI's native function supports coloring like above. Does this address your issue properly?
I have attached an example pbix file for your reference.
Best regards,
Sweden_25 I am not aware of when this feature will be implemented in Power BI. I do not believe it is on the roadmap: Microsoft Fabric Roadmap
Hi Sweden_25 ,
Thank you for reaching out to the Microsoft Community Forum.
Hi DataNinja777 and danextian , Thank you for your prompt responses.
Hi Sweden_25 , could you please try the proposed solutions shared by DataNinja777 and danextian ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.
Regards,
Dinesh
Hi Sweden_25 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hi,
Apologies for the delay. Yes thank you I reviewed these options. The most optimal solution (using groupings) from the suggestions required would still require manual editing of the groups (assigning each unique item to the group intended) that could lead to error and would need updating over time as new unique items are added to the dashboard. I will proceed with manually changing the colour of each item for now. It is not perfect but seems to be the simplist solution. Thank you.
