Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I have a column with a lot of modality (approximatively 100) and I want to use them as a legend in my stacked chart. The result is the following :
They don't have as much color as modality, consequently we see invisible bar chart. Only 84 modality have a color and I really need to see all of them. Can we change the color allocation limit ?
Solved! Go to Solution.
Hi @Irache ,
By default, Power BI uses a color palette with a limited number of colors, which can result in some categories not being assigned a unique color.
Please have a try.
Tips and tricks for formatting in reports - Power BI | Microsoft Learn
Define colors on a Power BI paginated report chart using a palette - Power BI | Microsoft Learn
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Irache ,
By default, Power BI uses a color palette with a limited number of colors, which can result in some categories not being assigned a unique color.
Please have a try.
Tips and tricks for formatting in reports - Power BI | Microsoft Learn
Define colors on a Power BI paginated report chart using a palette - Power BI | Microsoft Learn
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
Thanks for your advice I have already thought about these means but this is a mandatory information that I really need to show. I have found an alternative solution for my issue.
hi @Irache do you have a id on you rrecord, if such you can use that in the column conditional formatting section.
Consider having 100 categories, the id is from 1 - 100 thus the gradient scale will provide you what you need, e.g.:
It will doesn't work it's a categorial column.