andrew5083's avatar
andrew5083
Frequent Visitor
5 years ago
Status:
New

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".  

 

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.  

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
               }
            ]
         }
      }
   }
}

 

6 Comments

  • v-robertq-msft's avatar
    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's avatar
    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's avatar
    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's avatar
    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.