Invisible bar chart ?

[Irache]

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 ?

[v-rongtiep-msft · Accepted 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.

• Custom Color Palette:
  You can create a custom color palette by defining specific colors for each category.
• Grouping or Aggregating Data:
  Consider grouping similar modalities together. For instance, if you have multiple subcategories within a broader category, aggregate them.This reduces the number of distinct colors needed and simplifies the visualization.
• Alternate Visualization Types:
  If the stacked chart becomes too cluttered, explore other visualization types like a treemap, bar chart, or table.

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.

[Irache]

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. 

[rubinboer]

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.:

 

[Irache]

It will doesn't work it's a categorial column.