Forum Discussion
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
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.
