Forum Discussion
Anonymous
6 years agoNot applicable
PowerBI JSON Theme Slicer Default Mode to Dropdown
Hello, I am working on a JSON Theme file to make creating a reports front end more streamline. However, I am having diffcultly trying to get the slicers to default to the Dropdown Mode instead of th...
Jeroenadegraaf
1 year agoNew Member
Hello,
I tried the same today. PowerBI Desktop is still not responsive to the JSON for setting Slicer Default Mode to Dropdown.
This is the JSON that I used:
"slicer": {
"*": {
"data": [
{ "mode": "Dropdown" } // Comment: PowerBI still shows the default vertical list.
],
"header": [
{
"show": true,
"fontColor": {
"solid": {
"color": "#FFFFFF"
}
},
"textSize": 9,
"fontFamily": "Arial",
"background": {
"solid": {
"color": "#0091DC"
}
},
"border": [
{
"color": {
"solid": {
"color": "#FFFFFF"
}
},
"show": true,
"radius": 0
}
],
"outlineStyle": 4, // Comment: Line for bottom of header area. According to documentation Bottom should be a 2. But 2 shows a line on the left.
"outlineColor": {
"solid": {
"color": "#FFFFFF" } // Comment: Line color. The color of the line doesn't adjust to white when I apply the JSON.
},
"outlineWeight": 4
}
],
"background": [
{
"transparency": 100
}
],
"items": [
{
"fontColor": {
"solid": {
"color": "#000000"
}
},
"background": {
"solid": {
"color": "#FFFFFF"
}
},
"selectedColor": {
"solid": {
"color": "#0091DC"
}
},
"selectedFontColor": {
"solid": {
"color": "#FFFFFF"
}
},
"selectedFontWeight": "Bold",
"outline": "None",
"textSize": 8,
"fontFamily": "Arial",
"padding": 0
}
],
"title": [
{
"fontsize": 10,
"show": true,
"fontColor": {
"solid": {
"color": {
"expr": {
"ThemeDataColor": {
"ColorId": 1,
"Percent": 0
}
}
}
}
},
"fontFamily": "Arial"
}
],
"border": [
{
"color": {
"solid": {
"color": "#e3e5e5"
}
},
"show": false,
"radius": 0
}
]
}
},"
I hope Microsoft wil fix these bugs some day soon. (Or let me know what i'm doing wrong, which is also always a possibility of course.)