Forum Discussion
Chiclet Slicer / Themes JSON Edits
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
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" } ] } } } }ChicletSlicerProps must be renamed to ChicletSlicer1448559807354
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hello, same issue when we rename chiclets slicer to ChicletSlicer1448559807354
"ChicletSlicer1448559807354":{
"general":{
"orientation":"Horizontal",
"columns":1,
"rows":0
},
"header":{
"title":[
{
"show":false,
"fontColor":{
"solid":{
"color":"#0F0F0F"
}
},
"background":{
"solid":{
"color":"#E0E0E0"
}
},
"alignment":"left",
"fontSize":10,
"fontFamily":"'Segoe UI Bold', wf_segoe-ui_bold, helvetica, arial, sans-serif"
}
]
},
"Chiclets":{
"selectedColor": {
"solid": {
"color": "#A7DBFB"
}
},
"hoverColor": {
"solid": {
"color": "#4371C3"
}
},
"unselectedColor": {
"solid": {
"color": "#ffffff"
}
},
"disabledColor": {
"solid": {
"color": "#ffffff"
}
},
"outlineColor": {
"solid": {
"color": "#4371C3"
}
},
"textColor": {
"solid": {
"color": "#4371C3"
}
},
"outlineWeight":1,
"padding":1,
"borderStyle":"Cut"
}
}