Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Roshan_Pradhan
New Member

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.

 

Roshan_Pradhan_0-1714990133537.png

 

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Roshan_Pradhan ,

 

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

Blank Value:

vtianyichmsft_0-1715050557162.png

vtianyichmsft_1-1715050565423.png

0 Value:

vtianyichmsft_2-1715050612602.png

vtianyichmsft_3-1715050625932.png

 

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Roshan_Pradhan ,

 

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

Blank Value:

vtianyichmsft_0-1715050557162.png

vtianyichmsft_1-1715050565423.png

0 Value:

vtianyichmsft_2-1715050612602.png

vtianyichmsft_3-1715050625932.png

 

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.

johnbasha33
Super User
Super User

@Roshan_Pradhan 

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 !!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors