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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
jaykwilliams
Frequent Visitor

Chiclet Slicer / Themes JSON Edits

Is there currently a way to code a JSON theme file to adjust the default behavior for a chiclet slicer? My JSON file sets global visual styles (title) that are not applied to the chiclet slicers.

 

I've also tried using "chicletSlicer" to adjust the theme at the visual level, but have not been able to adjust the defaults.

 

 

22 REPLIES 22
Anonymous
Not applicable

I am using OCtober 2018 eidtiton of PBI desktpop and there are no options selected. There is also bug how visual is interacting with colors defined in my theme

 

chicet.gif 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

So far i have managed to set up each visual from my JSON theme file except Chiclet Slicer and Power KPI. Here is entire file:

{
	"name": "Tamedia V4",
	"dataColors": ["#000000","#00fac3", "#00d39a", "#4e4a46", "#fdcb00", "#fff500", "#d20052", "#ff0050", "#F5f5f4"],
	"background": "#FFFFFF",
	"foreground": "#666666",
	"tableAccent": "#999999", 

	"visualStyles": {
		"*": {
			"*": {
				"*": [{
						"responsive": true,
						"wordWrap": true,
						"wordWrap": true,
						"fontFamily": "Arial",
						"fontSize": 10

					}
				],
				"labels": [{
						"show": true,
						"fontSize": 9,
						"color": {
							"solid": {
								"color": "#000000"
							}
						},
						"labelOrientation": "horizontal"
					}
				],
				"categoryAxis": [{
						"showAxisTitle": true,
						"labelColor": {
							"solid": {
								"color": "#000000"
							}
						}
					}
				],
				"valueAxis": [{
						"showAxisTitle": true,
						"labelColor": {
							"solid": {
								"color": "#000000"
							}
						}
					}
				],
				"title": [{
						"show": true,
						"fontSize": 9,
						"fontColor": {
							"solid": {
								"color": "#000000"
							}
						}
					}
				],
				"legend": [{
						"labelColor": {
							"solid": {
								"color": "#000000"
							}
						}
					}
				]
			}
		},
		"lineClusteredColumnComboChart": {
			"*": {
				"labels": [{
						"show": true,
						"fontSize": 9,
						"labelOrientation": "vertical",
						"enableBackground": true,
						"backgroundColor": { "solid": { "color": "#ffffff"}},
						"backgroundTransparency": 20
					}
				],
				"legend": [{
						"show": false
					}
				],
				"valueAxis": [{
						"show": false,
						"showAxisTitle": false
					}
				],
				"categoryAxis": [{
						"show": true,
						"showAxisTitle": false
					}
				]	
			}
		},
		"lineChart": {
			"*": {
				"legend": [{
						"legendMarkerRendering": "lineAndMarker"
					}
				],
				"lineStyles": [{
						"showMarker": false,
						"showSeries": true
					}
				],
				"labels": [{
						"show": true,
						"fontSize": 9
					}
				],
				"dataLabels": [{
						"show": true
					}
				]
			}
		},
		"clusteredBarChart": {
			"*": {
				"labels": [{
						"show": true,
						"fontSize": 9
					}
				],
				"dataLabels": [{
						"show": true
					}
				],
				"categoryLabels": [{
						"show": true
					}
				],
				"categoryAxis": [{
						"axisType": "Categorical"
					}
				]
			}
		},
		"clusteredColumnChart": {
			"*": {
				"labels": [{
						"show": true,
						"fontSize": 9,
						"labelOrientation": "vertical",
						"enableBackground": true,
						"backgroundColor": { "solid": { "color": "#ffffff"}},
						"backgroundTransparency": 20
					}
				],
				"categoryLabels": [{
						"show": true
					}
				],
				"categoryAxis": [{
						"axisType": "Categorical"
					}
				]
			}
		},
		"kpi17922CFD0D3E4D33B4D8C3EB36C178D7_OrgStore": {
			"*": {
				"nameSettings": [{
						"valueName": "",
						"nameFontSize": "8",
						"nameFontFamily": "Arial"
					}
				],
				"valueSettings": [{
						"valueFontSize": "24",
						"valueUnit": "Thousend",
						"valueUnitFlag": false,
						"valuePrecision": "1",
						"valueFontFamily": "Arial"
					}
				],
				"planSettings": [{
						"planFontSize": "10",
						"planUnit": "Thousend",
						"planUnitFlag": false,
						"planPrecision": "1",
						"planPercentPrecision": "0",
						"planFontFamily": "Arial"
					}
				],
				"lastSettings": [{
						"lastFontSize": "10",
						"lastUnit": "Thousend",
						"lastUnitFlag": false,
						"lastPrecision": "1",
						"lastPercentPrecision": "0",
						"lastFontFamily": "Arial"
					}
				],
				"arrowSettings": [{
						"negativeFlag": false,
						"arrowSize": 12
					}
				],
				"renderGroup": [{
						"commaSettingShow": false
					}
				],
				"title": [{
						"show": true,
						"alignment": "left",
						"fontSize": 9,
						"fontFamily": "Arial"
					}
				],
				"background": [{
						"show": false
					}
				],
				"lockAspect": [{
						"show": false
					}
				],
				"border": [{
						"show": false
					}
				]
			}
		},
		"stackedChart6B1A1115A38741C7B49B956F1C12C623_OrgStore": {
			"*": {
				"dataPoint": [{
						"defaultColor": {
							"solid": {
								"color": "#D3D3D3"
							}
						},
						"showAllDataPoints": false
					}
				],
				"dataPointStroke": [{
						"defaultColor": {
							"solid": {
								"color": "#A9A9A9"
							}
						},
						"showAllDataPoints": false
					}
				],
				"dataPointLabel": [{
						"defaultColor": {
							"solid": {
								"color": "#000000"
							}
						},
						"showAllDataPoints": false
					}
				],
				"axis": [{
						"show": false,
						"fontFamily": "Arial",
						"color": {
							"solid": {
								"color": "#000000"
							}
						},
						"fontSize": 10
					}
				],
				"labels": [{

						"show": true,
						"fontFamily": "Arial",
						"color": {
							"solid": {
								"color": "#000000"
							}
						},
						"fontSize": 8,
						"paddingSize": 20
					}
				],
				"columnlabels": [{

						"show": true,
						"fontFamily": "Arial",
						"color": {
							"solid": {
								"color": "#000000"
							}
						},
						"fontSize": 8,
						"paddingSize": 20,
						"columnLabelDataUnit": "Thousend",
						"unitFlag": true,
						"columnLabelDataPrecision": "1"

					}
				],
				"smallmultiplelabels": [{

						"show": true,
						"fontFamily": "Arial",
						"color": {
							"solid": {
								"color": "#000000"
							}
						},
						"fontSize": 8
					}
				],
				"renderGroup": [{

						"renderFullPart": true,
						"renderOthers": false,
						"renderOthersPercent": 5,
						"renderOverflow": false,
						"commaSettingShow": false,
						"decimalSymbol": ".",
						"digitGroupingSymbol": ","
					}
				],
				"title": [{
						"show": true,
						"fontColor": {
							"solid": {
								"color": "#000000"
							}
						},
						"background": {
							"solid": {
								"color": "#FFFFFF"
							}
						},
						"alignment": "left",
						"fontSize": 9,
						"fontFamily": "Arial"
					}
				],
				"background": [{
						"show": false,
						"color": {
							"solid": {
								"color": "#FFFFFF"
							}
						},
						"transparency": 50
					}
				],
				"border": [{
						"show": false,
						"color": {
							"solid": {
								"color": "#000000"
							}
						}
					}
				]
			}
		},
		"pivotTable": {
			"*": {
				"grid": [{
						"gridVertical": false,
						"gridHorizontalColor": {
							"solid": {
								"color": "#E7E7E7"
							}
						},
						"rowPadding": 6,
						"outlineColor": {
							"solid": {
								"color": "#b3b3b3"
							}
						},
						"outlineWeight": 2,
						"textSize": 8
					}
				],
				"columnHeaders": [{
						"gridAlignment": "Right"
					}
				],
				"values": [{
						"valuesOnRow": true
					}
					
				],				
				"subTotals": [{
						"columnSubtotals": false,
						"textSize": 8
					}
					
				],
				"total": [{
						"textSize": 8
					}
				]	
				
			}
		},
		"tableEx": {
			"*": {
				"grid": [{
						"gridVertical": false,
						"gridHorizontalColor": {
							"solid": {
								"color": "#E7E7E7"
							}
						},
						"rowPadding": 6,
						"outlineColor": {
							"solid": {
								"color": "#b3b3b3"
							}
						},
						"outlineWeight": 2,
						"textSize": 8
					}
				],
				"columnHeaders": [{
						"gridAlignment": "Right"
					}
				],
				"values": [{
						"valuesOnRow": true
					}
					
				],				
				"subTotals": [{
						"columnSubtotals": false,
						"textSize": 8
					}
					
				],
				"total": [{
						"textSize": 8
					}
				]	
				
			}
		},			
		"powerKPI462CE5C2666F4EC8A8BDD7E5587320A3": {
			"*": {
				"kpiIndicatorProperties": [{
						"show": false,
						"fontSize": 11
					}
				],
				"dataLabelSettings": [{
						"units": "K",
						"showUnits": "2"
					}
				]
			}
		},			
		"ChicletSlicer1448559807354": {
			"*": {
				"general": {
						"orientation": "Horizontal",
						"multiselect": false,
						"forcedSelection": false
					},
				"rows": [{
						"fontColor": {
							"solid": {
								"color": "#ffffff"
							}
						},
						"textSize": 8,
						"height":22,
						"width":84,
						"selectedColor": {
							"solid": {
								"color": "#000000"
							}
						},
						"hoverColor": {
							"solid": {
								"color": "#808080"
							}
						},
						"unselectedColor": {
							"solid": {
								"color": "#b3b3b3"
							}
						},
						"outlineWeight":1,
						"padding":1,
						"borderStyle":"Cut"
						
						
					}
				]
			}
		},

      "ChicletSlicer1448559807354":{  
         "general":{  
            "orientation":"Horizontal",
            "rows":5
         },
         "header":{  
            "title":[  
               {  
                  "show":true,
                  "fontColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "background":{  
                     "solid":{  
                        "color":"#E0E0E0"
                     }
                  },
                  "alignment":"left",
                  "fontSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ]
         }
      }
	}
}

 

v-viig
Community Champion
Community Champion

This is known issue that we will resolved pretty soon.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Anonymous
Not applicable

Having the same problem. Would love to be able to use theming json for chiclet slicer.

v-viig
Community Champion
Community Champion

This is known issue that will be resolved soon.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

RJRMP
Frequent Visitor

Has this been solved? I can't seem to be able to apply theming to chiclet slicer through json files using the August 2.61.5192.641 PowerBI Desktop for Report Server version.

v-evelk
Microsoft Employee
Microsoft Employee

I am checking the info regarding this issue.

I will provide status asap.

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

v-evelk
Microsoft Employee
Microsoft Employee

I checked Februar version and Chiclet Slicer works with themes fine there.

There is only one moment.

If it uses default colors they will not be changed (looks like some moment that should be fixed in visual).

But if non-default colors were chosen theme changing will work as awaited.

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

RJRMP
Frequent Visitor

So should the below theming file work for the Chiclet slicer? If not the colours, then atleast the padding and outline style of the chiclets? I can't get it to work.

 

{
	"name": "Chiclet theme",
	"tableAccent": "#7D1D30",
	"visualStyles": {
		"ChicletSlicer1448559807354": {
			"*": {
				"rows": [
					{
						"textSize": 12,
						"padding": 1,
						"selectedColor": {
							"solid": {
								"color": "#7D1D30"
							}
						},
						"unselectedColor": {
							"solid": {
								"color": "#8B8B84"
							}
						},
						"fontColor": {
							"solid": {
								"color": "#F5F5F5"
							}
						},
						"borderStyle": "Square"
					}
				]
			}
		}
	}
}
v-viig
Community Champion
Community Champion

PBI Themes used to work with Custom Visuals.

 

Will ask the development team to investigate this issue deeper.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

I am also seeing this issues. if I add the follwoing code to my JSON file, the border styling is correctly added but the header and row styling is not.

 

"ChicletSlicer1448559807354": {
  "*": {
    "header": [{
      "show": false
    }],
    "rows": [{
      "selectedColor": { "solid": { "color": "#01a982"}},
      "borderStyle": "Rounded"
    }],

    "border": [{
      "show": true
    }]
  }
}

Hi,

 

There are some limitations regarding applying of themes for Chiclet slicer because it still uses API 1.13 and there is specific reason why we cannot update it to API 2.x for a while

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Many thanks fro you reply.

Any updates on this, or timeline for possible update?

 

Thanks

v-evelk
Microsoft Employee
Microsoft Employee

Hello,

 

Unfortunatelly, Chiclet Slicer still uses API 1.13 and has limitations regarding themes applying.

However, we currently are trying to solve an issue with filtration to update the visual to the latest API so, as soon as we solve the issue, we will update the visual.

 

Kind Regards,

 

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com

Anonymous
Not applicable

I am having same issue, and it is not working after rename eather.

 

		"ChicletSlicer1448559807354": {
			"*": {
				"general": {
						"orientation": "Vertical",
						"multiselect": false,
						"forcedSelection": false
					},
				"rows": [{
						"fontColor": {
							"solid": {
								"color": "#ffffff"
							}
						},
						"textSize": 8,
						"height":22,
						"width":84,
						"selectedColor": {
							"solid": {
								"color": "#000000"
							}
						},
						"hoverColor": {
							"solid": {
								"color": "#808080"
							}
						},
						"unselectedColor": {
							"solid": {
								"color": "#b3b3b3"
							}
						},
						"outlineWeight":1,
						"padding":1,
						"borderStyle":"Cut"
						
						
					}
				]
			}
		}
v-viig
Community Champion
Community Champion

Were any options applied? What verison of Power BI Desktop did you use?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

v-viig
Community Champion
Community Champion

Can you share what Chiclet Slicer styles you wanna customize?

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

I was hoping to do something like the below code to edit the default orientation, number of rows, title style and font.

 

      "ChicletSlicerProps":{ 
         "general":{ 
            "orientation":"Horizontal",
            "rows":5
         },
         "header":{ 
            "title":[ 
               { 
                  "show":true,
                  "fontColor":{ 
                     "solid":{ 
                        "color":"#0F0F0F"
                     }
                  },
                  "background":{ 
                     "solid":{ 
                        "color":"#E0E0E0"
                     }
                  },
                  "alignment":"left",
                  "fontSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ]
         }

Does it work? If not, please share the whole Power BI Theme file to check it out from our side.

 

Ignat Vilesov,

Software Engineer

 

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

This theme worked with the exception of the Chiclet slicer formatting. 

{  
   "name":"Gray Title Bars",
   "background":"#FFFFFF",
   "foreground":"#0F0F0F",
   "tableAccent":"#0F0F0F",
   "dataColors":[  
      "#00A8FF",
      "#FF8100",
      "#6200FF"
   ],
   "visualStyles":{  
      "*":{  
         "*":{  
            "title":[  
               {  
                  "show":true,
                  "fontColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "background":{  
                     "solid":{  
                        "color":"#E0E0E0"
                     }
                  },
                  "alignment":"left",
                  "fontSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ],
            "background":[  
               {  
                  "show":false,
                  "color":{  
                     "solid":{  
                        "color":"#ffffff"
                     }
                  },
                  "transparency":50
               }
            ],
            "lockAspect":[  
               {  
                  "show":true
               }
            ],
            "border":[  
               {  
                  "show":false,
                  "color":{  
                     "solid":{  
                        "color":"#ffffff"
                     }
                  }
               }
            ],
            "visualTooltip":[  
               {  
                  "type":"Default"
               }
            ],
            "stylePreset":[  
               {  
                  "name":"Minimal"
               }
            ]
         }
      },
      "page":{  
         "*":{  
            "background":[  
               {  
                  "color":{  
                     "solid":{  
                        "color":"#ffffff"
                     }
                  },
                  "transparency":100
               }
            ],
            "outspace":[  
               {  
                  "color":{  
                     "solid":{  
                        "color":"#ffffff"
                     }
                  },
                  "transparency":0
               }
            ]
         }
      },
      "tableEx":{  
         "*":{  
            "grid":[  
               {  
                  "gridVertical":false,
                  "gridHorizontal":false,
                  "rowPadding":3,
                  "outlineColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "outlineWeight":1,
                  "textSize":8
               }
            ],
            "title":[  
               {  
                  "show":true,
                  "fontColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "background":{  
                     "solid":{  
                        "color":"#E0E0E0"
                     }
                  },
                  "alignment":"left",
                  "fontSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ],
            "columnHeaders":[  
               {  
                  "fontColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "backColor":{  
                     "solid":{  
                        "color":"#e0e0e0"
                     }
                  },
                  "autoSizeColumnWidth":true,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif",
                  "fontSize":8
               }
            ],
            "total":[  
               {  
                  "fontColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "backColor":{  
                     "solid":{  
                        "color":"#e0e0e0"
                     }
                  },
                  "autoSizeColumnWidth":true,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif",
                  "fontSize":8
               }
            ]
         }
      },
      "pivotTable":{  
         "*":{  
            "grid":[  
               {  
                  "gridVertical":false,
                  "gridHorizontal":false,
                  "rowPadding":3,
                  "outlineColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "outlineWeight":1,
                  "textSize":8
               }
            ],
            "title":[  
               {  
                  "show":true,
                  "fontColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "background":{  
                     "solid":{  
                        "color":"#E0E0E0"
                     }
                  },
                  "alignment":"left",
                  "fontSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ],
            "columnHeaders":[  
               {  
                  "fontColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "backColor":{  
                     "solid":{  
                        "color":"#e0e0e0"
                     }
                  },
                  "autoSizeColumnWidth":true,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif",
                  "fontSize":8
               }
            ],
            "total":[  
               {  
                  "fontColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "backColor":{  
                     "solid":{  
                        "color":"#e0e0e0"
                     }
                  },
                  "autoSizeColumnWidth":true,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif",
                  "fontSize":8
               }
            ]
         }
      },

      "ChicletSlicerProps":{  
         "general":{  
            "orientation":"Horizontal",
            "rows":5
         },
         "header":{  
            "title":[  
               {  
                  "show":true,
                  "fontColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "background":{  
                     "solid":{  
                        "color":"#E0E0E0"
                     }
                  },
                  "alignment":"left",
                  "fontSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ]
         }
      },
      "slicer":{  
         "*":{  
            "header":[  
               {  
                  "show":true,
                  "fontColor":{  
                     "solid":{  
                        "color":"#007EBF"
                     }
                  },
                  "alignment":"left",
                  "textSize":10,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ],
            "items":[  
               {  
                  "fontColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "outline":"None",
                  "textSize":9,
                  "fontFamily":"Segoe UI"
               }
            ]
         }
      },
      "scatterChart":{  
         "*":{  
            "categoryAxis":[  
               {  
                  "show":true,
                  "labelColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "fontSize":8,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif",
                  "titleColor":{  
                     "solid":{  
                        "color":"#0F0F0F"
                     }
                  },
                  "titleFontSize":8,
                  "titleFontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ],
            "valueAxis":[  
               {  
                  "show":true,
                  "labelColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "fontSize":8,
                  "fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif",
                  "titleColor":{  
                     "solid":{  
                        "color":"#0f0f0f"
                     }
                  },
                  "titleFontSize":8,
                  "titleFontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
               }
            ]
         }
      }
   }
}

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors
Top Kudoed Authors