Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Report Themes - Enable further format options via JSON

Hi,

 

 

I'm looking for a possility to creat a template theme I can use for reports.
To preconfigure colors is not an issue. But how can I enable further format options such as "Data labels".
It seems to me that the list of options on https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-themes/ is not complete in order to configure all possible format options.
Do you have any experience so far or hints reagrding this issue?

 

Thanks a lot.

Dom

  • Hi Anonymous,

     

    Please download the sample JSON file here. You can import the theme file into your pbix file to see whether it works. Also, you can open the json file as a reference, to see how to correctly set data labels for chart visual.

     

    Best regards,
    Yuliana Gu

6 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi Anonymous,

     

    Since Power BI desktop September update, more theme file format was added to include full control over your chart styling.

    This means you can do things like:

    • Set all your charts to use size 14 font
    • Set your matrix values to use Calibri font
    • Turn data labels on for specific charts

     

    Reference: Theming preview update – chart style controls

     

    If you want more format options which are not supported now, you could submit it at idea page.

     

    Best regards,
    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-yulgu-msft,

       

      That was the information I was looking for. So far I only checked the documentation on https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-themes/ but I overlooked the information of the link you have provided. Thanks.

      Anyway, I'm still unable to actiate the format option "Data labels":

       

       

      My JSON file looks like this at the moment:

       

      {
          "name": "BringItOn",
          "dataColors": [
              "#6876ff",
              "#a9d1f4",
              "#63bb80",
              "#783b3c",
              "#000831",
              "#141256",
              "#d0d0d7"
          ],
          "background": "#f2f2f3",
          "foreground": "#575760",
          "tableAccent": "#aba9f4",
          "visualStyles":{
              "*":{
                  "*":{
                      "*":[{
                          "fontSize":14,
                          "fontFamily":"Arial",
                          "dataLabels": [{
                          			   "show": true
                          			}],							
                          "axisType": [{
                                        "value": "Categorical",
                      		  "displayName": "Categorical"
                      									}]
                      }]
                  }
              }
           }
      }

       

       

      I also tried the cardName"labels", which is refering to "Data labels" according to the documentation on  https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-report-themes/.

       

      Any ideas?

       

      Cheers,

      Dom

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee

        Hi Anonymous,

         

        Please download the sample JSON file here. You can import the theme file into your pbix file to see whether it works. Also, you can open the json file as a reference, to see how to correctly set data labels for chart visual.

         

        Best regards,
        Yuliana Gu