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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Segoe UI Bold JSON Bug?

I think there may be a bug when referencing Segoe UI Bold in JSON for Power BI Themes.

 

In the screenshot below, I'd like to have the column headers formatted as "Segoe UI Bold".  

andrew5083_0-1624982402643.png

 

The theme imports into Power BI successfully and the font shows as "Segoe UI Bold", but the column headers are formatted as some other font.  

andrew5083_1-1624982478647.png

If I change to a different font, then back to Segoe UI Bold, the column headers are formatted correctly.  Additionally, if I change the JSON reference to "fontFamily": "wf_segoe-ui_bold", this also works, but it displays the font as "wf_segoe-ui_bold" in Power BI, which I'd like to avoid.

 

JSON theme

 

{
   "name":"KSMI Theme",
   "textClasses":{
      "label":{
         "fontSize":8
      },
      "title":{
         "fontSize":9,
         "color":"#6E79A1"
      }
   },
   "dataColors":[
      "#73B761",
      "#4A588A",
      "#ECC846",
      "#CD4C46",
      "#71AFE2",
      "#8D6FD1",
      "#EE9E64",
      "#95DABB",
      "#3599B8",
      "#DFBFBF",
      "#4AC5BB",
      "#5F6B6D",
      "#FB8281",
      "#F4D25A",
      "#7F898A",
      "#A4DDEE",
      "#FDAB89",
      "#B687AC",
      "#28738A",
      "#A78F8F",
      "#168980",
      "#293537",
      "#BB4A4A",
      "#B59525",
      "#475052",
      "#6A9FB0",
      "#BD7150",
      "#7B4F71",
      "#1B4D5C",
      "#706060",
      "#0F5C55",
      "#1C2325"
   ],
   "bad":"#E81123",
   "neutral":"#F2C811",
   "good":"#3BB44A",
   "minimum":"#FD625E",
   "center":"#F5D33F",
   "maximum":"#01B8AA",
   "visualStyles":{
      "tableEx":{
         "*":{
            "grid":[
               {
                  "outlineColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  }
               }
            ],
            "columnHeaders":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  },
                  "fontFamily":"Segoe UI Bold",
                  "fontSize":8
               }
            ],
            "total":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#384268"
                     }
                  },
                  "fontFamily":"Segoe UI",
                  "fontSize":8
               }
            ]
         }
      },
      "pivotTable":{
         "*":{
            "stylePreset":[
               {
                  "name":"Default"
               }
            ],
            "grid":[
               {
                  "gridVerticalColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  },
                  "gridHorizontalColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  },
                  "outlineColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  },
                  "textSize":8
               }
            ],
            "columnHeaders":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  },
                  "fontFamily":"Segoe UI Bold",
                  "fontSize":8
               }
            ],
            "rowHeaders":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#384268"
                     }
                  },
                  "fontFamily":"Segoe UI",
                  "fontSize":8
               }
            ],
            "subTotals":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#384268"
                     }
                  },
                  "fontFamily":"Segoe UI",
                  "fontSize":8
               }
            ],
            "total":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#384268"
                     }
                  },
                  "fontFamily":"Segoe UI",
                  "fontSize":8
               }
            ]
         }
      },
      "page":{
         "*":{
            "background":[
               {
                  "color":{
                     "solid":{
                        "color":"#929BB9"
                     }
                  },
                  "transparency":50
               }
            ]
         }
      }
   }
}

 

Status: New
Comments
v-robertq-msft
Community Support

Hi, @andrew5083 

I have reported this issue internally, ICM: 248292262

I will update here once I get any information.

 

Best Regards,

Community Support Team _Robert Qin

v-xuding-msft
Community Support

Hi @andrew5083 ,

 

 Update theme file fontFamily to be as below. Please have a try.

"columnHeaders":[
               {
                  "fontColor":{
                     "solid":{
                        "color":"#4A588A"
                     }
                  },
                  "fontFamily":"'Segoe UI Bold',wf_segoe-ui_bold",

 

andrew5083
Frequent Visitor

@v-xuding-msft, as I mentioned I'd like to avoid using that reference because:

 

If I change to a different font, then back to Segoe UI Bold, the column headers are formatted correctly.  Additionally, if I change the JSON reference to "fontFamily": "wf_segoe-ui_bold", this also works, but it displays the font as "wf_segoe-ui_bold" in Power BI, which I'd like to avoid.

v-xuding-msft
Community Support

Hi @andrew5083 ,

 

Sorry that I missed the important information. If you are urgent for this report, it is better to try "fontFamily": "wf_segoe-ui_bold". The report viewers will be not able to see it in Format through sharing by Power BI Service.

 

 And I've reported it to product group team. If there is any updates, I will post here.Thanks for your patience.

andrew5083
Frequent Visitor

@v-xuding-msft thank you for reporting it!  I will try your suggestion in the meantime.