Theme saved in Power BI can't be imported back due to validation

[kelseyp]

Hi,

Power BI desktop is updated today and our custom themes are not working anymore. Even when we tried to save the custom from Power BI, it can't be imported back:

This is the error:

#/visualStyles/barChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/barChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/barChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/barChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/barChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/barChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/columnChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/columnChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/columnChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/columnChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/columnChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/columnChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredBarChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredBarChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredBarChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredBarChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredBarChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredBarChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredColumnChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredColumnChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredColumnChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredColumnChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredColumnChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/clusteredColumnChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedBarChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedBarChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedBarChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedBarChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedBarChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedBarChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedColumnChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedColumnChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedColumnChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedColumnChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedColumnChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/hundredPercentStackedColumnChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/areaChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/areaChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/areaChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/areaChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/areaChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/areaChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/stackedAreaChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/stackedAreaChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/stackedAreaChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/stackedAreaChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/stackedAreaChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/stackedAreaChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/valueAxis/0/secFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/valueAxis/0/secTitleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineStackedColumnComboChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/legend/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/categoryAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/categoryAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/valueAxis/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/valueAxis/0/titleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/valueAxis/0/secFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/valueAxis/0/secTitleFontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/lineClusteredColumnComboChart/*/labels/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/visualStyles/kpi/*/title/0/fontSize must be number (type; matching schema #/definitions/fontSize/type)
#/icons must be array (type; matching schema #/properties/icons/type)

Could this please be looked at. Thank you.

[kelseyp]

@v-xiaoyan-msft  my Power BI version:

[KaroCka]

@LauraWalczak 

It works! Thank you. It's not very helpful that you can't tell which url represends which icon, but it works so I stop complaining. 😊

[Gazzer]

The schema being validated does not appear to match the actual schema required.

For example, choosing which style of slicer you want is in "General" in the validation, but is now in the "Visual" tab for formatting. Plus, the validation will only accept one of two options (0 or 1) but there are three options available. This means you can only choose Vertical List or Tile, you cannot set Dropdown as the default type.

I'm using 2.114.664.0 February 2023

[v-xiaoyan-msft]

Hi @kelseyp ,

Please ensure the .json file is constructed correctly by referring the following link: Use report themes in Power BI Desktop - Power BI | Microsoft Learn and at the first time when you import the file it will not apply to the existing visuals , you have to use the 'revert to default' option refer link: Power bi .json Custom Theme - Revert visuals to default · Issue #2230 · MicrosoftDocs/powerbi-docs ·....

Best regards.
Community Support Team_ Caitlyn

[blublood]

@v-xiaoyan-msft - 

To clarify your advice:

• Please ensure that the .json file is properly constructed, as described in the following article
  • Use report themes in Power BI Desktop - Power BI | Microsoft Learn
• When importing a .json theme, existing visuals will not apply the new theme if the visual format has been customized.  To apply the theme to customized visuals, the format of the visual must be reset using 'revert to default' as described in the following article:
  • Power bi .json Custom Theme - Revert visuals to default · Issue #2230 · MicrosoftDocs/powerbi-docs ·...

[AmyJessica02]

Thank you @LauraWalczak 

[Jperez2k8]

Same errror: #/icons must be array (type; matching schema #/properties/icons/type)

I can confirm the same .json theme file worked perfectly before the February update

[Anonymous]

@v-xiaoyan-msft  unfortunately it doesn't help.
Still error message:  '#/icons must be array (type; matching schema #/properties/icons/type)'

Please solve this we need the icons to get work for our embedded (to customers) product!

Thank you!

[odiallo]

@DavidP and @KaroCka or anyone who resolved those issues. Could you please provide samples scripts and explain how you resolved them. Thank you

[KaroCka]

Hi @odiallo, 

I only had a problem with slicer mode Dropdown and icons didn't upload with description and the name.

Therefore I've just simply removed those details from my file 

before:

"icons": {
"GreenDash": {"description": "Green Dash", "url": "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 15 15'> <rect x='0.5' y='5.5' fill='%2384C28A' width='14' height='4'/> <path fill='%23449E44' d='M0,5v5h15V5H0z M14,9.001H1V6h13V9.001z'/> </svg>"}

after:

 "icons": 
{
"url": "data&colon;image/svg+xml;utf8, <svg xmlns='http://www.w3.org/2000/svg' viewBox='0 0 15 15'> <rect x='0.5' y='5.5' fill='%2384C28A' width='14' height='4'/> <path fill='%23449E44' d='M0,5v5h15V5H0z M14,9.001H1V6h13V9.001z'/> </svg>"
}

I recommend using the following theme generator, it  gives a wide range of properities. It's been recently updated inline with the latest pbi changes.

https://themegenerator.point-gmbh.com/en/visuals/Global%20Level

I also use the following butyfier to check if my code is correct

https://jsonformatter.org/ 

Hope it helps.