Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI Color Coding

I have created a dashboard with pie chart on it, i have cretaed the pie chart with 5 categories. There were 5 colors assigned and then when i am trying to change the data and see the dashboard the colors shift. Please refer the below snap for example.

 

 

Please provide a way out so that the color coding remains same even if any category have 0 values or is Blank

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    If possible, replace the blank value with 0 to keep the original style, you can refer to the following picture:

    Blank Value:

    0 Value:

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous 

    To ensure that the colors remain consistent in your pie chart even when some categories have zero values or are blank, you can manually assign colors to each category using the "Data colors" option in Power BI. Here's how you can do it:

    1. In Power BI Desktop, select the pie chart visual on your dashboard.

    2. In the "Visualizations" pane, select the "Format" section (paint roller icon).

    3. Scroll down to the "Data colors" section.

    4. By default, Power BI automatically assigns colors to categories. To manually assign colors:
    - Toggle off the "Automatic" option.
    - Manually assign colors to each category by clicking on the color box next to the category name and selecting a color from the palette.

    5. Assign colors to each category based on a consistent color scheme that you prefer.

    6. After assigning colors manually, the colors will remain consistent regardless of changes in the data, such as zero values or blank categories.

    By manually assigning colors to each category, you ensure that the color coding remains consistent even when the data changes. This approach allows you to maintain visual consistency in your pie chart across different datasets.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    If possible, replace the blank value with 0 to keep the original style, you can refer to the following picture:

    Blank Value:

    0 Value:

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.