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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
rayishome
Resolver I
Resolver I

Custom Themes not working when using a slicer

We are running the June update to Power BI and experiencing an issue with Bar Charts randomly picking a color and ignoring the Theme when using a slicer.  We have a column with 1000's of possible values, but split by category, that may be grouped in a chart.  When the Theme is applied and the slicer is used to select a new category returning a smaller number of rows (20 to 50) the theme is ignored and random colors are selected.  

 

Is this an existing bug with a workaround? 

 

Thanks

2 REPLIES 2
v-xicai
Community Support
Community Support

Hi @rayishome ,

 

>>We have a column with 1000's of possible values, but split by category, that may be grouped in a chart. 

 

Assuming this column is put into Legend box of Bar chart, when make selections in slicer visual, the corresponding different color categories of chart will be returned generally. While for every kind of category, there will be only one color related to it. You may check if the color for per category is the same when you filter in slicer.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

It looks like, according to PBI Support, Themes will not work correctly by design with any column that has more than a few rows of data.  For example if you have Product and Product Category fields with 10 Product Categories and 10 Products in each Product the Theme will break even if you require the user to filter by Product Category and never show more than 10 Products at a time.  This is due to the "dataColors" array where the series is assigned colors.  Once the series value is assigned a color from the pallet it won't be used again even if the value is no long within the dataset due to filters.  If you have 30 colors in your Theme and select the first 3 Product Categories and display 10 products each the color pallet is exausted and the 4th Product Category selected with have random and wild colors.   

 

@v-xicai 

 

  

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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 Solution Authors
Top Kudoed Authors