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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
johanjsc
Helper I
Helper I

Json Theme - Enable background for gauge by default

Hi!

 

Tried to read and understand this from the extensive site here: https://docs.microsoft.com/en-us/power-bi/desktop-report-themes

But my programming knowledge is a bit to low, and i struggle to find out how to set Background=True on my Gauge meters.

The color and transparency works, but by default the On/Off switch for the Background is still Off. Please advise what i need to add in my json file to make my gauges automatically swith Background = On

 

{
"name":"PowerBI Demo",
"dataColors":["#003366", "#A8C5E0", "#214F80", "#A4D3E3", "#82A1BD", "#366996", "#304E64", "#004576", "#666666", "#000000", "#0C304A", "#0076DE"],
"background":"#FFFFFF",
"foreground":"#003366",
"tableAccent":"#214F80",

"visualStyles":
{
"page": {
"*": {
"background": [
{
"color": {
"solid": {
"color": "#ebeef2"
}
},
"transparency": 0
}]
}
},
"gauge":{
"*":{
"background":[{
"color":{
"solid":{
"color":"#ffffff"
}
},
"transparency": 0
}
]
}
}
}
}

1 ACCEPTED SOLUTION
v-lid-msft
Community Support
Community Support

Hi @johanjsc ,

 

I found a solution in the end of this post. we can use the following json to meet your requirement. Notice the blue part that control the show status of visual.

 

{
"name":"PowerBI Demo",
"dataColors":["#003366", "#A8C5E0", "#214F80", "#A4D3E3", "#82A1BD", "#366996", "#304E64", "#004576", "#666666", "#000000", "#0C304A", "#0076DE"],
"background":"#000000",
"foreground":"#003366",
"tableAccent":"#214F80",
"visualStyles": {
	"gauge": {
		"*": {
                "background": [{
		    "show": {
                        "expr": {
                            "Literal": {
                                "Value": "true"
                            }
                        }
                    },
                "color": { "solid": { "color": "#FF0000" } },
                "transparency": 25
            }]
		}
	},
    "page": {
            "*": {
                "background": [{
                "color": { "solid": { "color": "#FFFFFF" } },
                "transparency": 25
            }],
            "outspace": [{
                "color": { "solid": { "color": "#004753" } },
                "transparency": 0
            }]
        }
    }
    }
}

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lid-msft
Community Support
Community Support

Hi @johanjsc ,

 

I found a solution in the end of this post. we can use the following json to meet your requirement. Notice the blue part that control the show status of visual.

 

{
"name":"PowerBI Demo",
"dataColors":["#003366", "#A8C5E0", "#214F80", "#A4D3E3", "#82A1BD", "#366996", "#304E64", "#004576", "#666666", "#000000", "#0C304A", "#0076DE"],
"background":"#000000",
"foreground":"#003366",
"tableAccent":"#214F80",
"visualStyles": {
	"gauge": {
		"*": {
                "background": [{
		    "show": {
                        "expr": {
                            "Literal": {
                                "Value": "true"
                            }
                        }
                    },
                "color": { "solid": { "color": "#FF0000" } },
                "transparency": 25
            }]
		}
	},
    "page": {
            "*": {
                "background": [{
                "color": { "solid": { "color": "#FFFFFF" } },
                "transparency": 25
            }],
            "outspace": [{
                "color": { "solid": { "color": "#004753" } },
                "transparency": 0
            }]
        }
    }
    }
}

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Exactly what I was looking for - many thanks for quick and good reply!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.