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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

JSON data labels customize series

Hi all,

 

In scope of my project I need to create a JSON theme in order to customize the data labels (font size, color etc.) for a line and column combo chart. Is there a way to do this only for the line and not the columns using JSON theme?

 

Thank you in advance.

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

Hi @Anonymous ,

 

Sorry for that the Power BI cannot change the each label’s theme using JSON file. We can only configure each value theme in Customize Series.

 

JSON 1.jpg

 

JSON 2.jpg

 

But use the JSON file we can change the label’s overall theme. The JSON file like this, and you can refer it.

 

{
   "name":"LineClusteredColumnComboTemplate",
   "visualStyles":{
      "lineClusteredColumnComboChart":{
         "*":{
            "labels":[
               {
                  "show":true,
                  "color":{
                     "solid":{
                        "color":"#EEEEEE"
                     }
                  },
                  "labelDisplayUnits":"0",
                  "labelPrecision":1,
                  "labelOrientation":"vertical",
                  "labelPosition":"OutsideEnd",
                  "fontSize":11,
                  "fontFamily":"Courier New",
                  "enableBackground":true,
                  "backgroundColor":{
                     "solid":{
                        "color":"#0928DD"
                     }
                  },
                  "backgroundTransparency":30
               }
            ],
            "lineStyles":[
               {
                  "shadeArea":true,
                  "strokeWidth":4,
                  "strokeLineJoin":"bevel",
                  "showMarker":true,
                  "markerShape":"triangle",
                  "markerSize":3,
                  "markerColor":{
                     "solid":{
                        "color":"#448822"
                     }
                  }
               }
            ]
         }
      }
   }
}

 

If you have any questions, please kindly ask here and we will try to resolve it.

BTW, the JSON file as attached.    

 

Best regards,

 

Community Support Team _ zhenbw

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

1 REPLY 1
v-zhenbw-msft
Community Support
Community Support

Hi @Anonymous ,

 

Sorry for that the Power BI cannot change the each label’s theme using JSON file. We can only configure each value theme in Customize Series.

 

JSON 1.jpg

 

JSON 2.jpg

 

But use the JSON file we can change the label’s overall theme. The JSON file like this, and you can refer it.

 

{
   "name":"LineClusteredColumnComboTemplate",
   "visualStyles":{
      "lineClusteredColumnComboChart":{
         "*":{
            "labels":[
               {
                  "show":true,
                  "color":{
                     "solid":{
                        "color":"#EEEEEE"
                     }
                  },
                  "labelDisplayUnits":"0",
                  "labelPrecision":1,
                  "labelOrientation":"vertical",
                  "labelPosition":"OutsideEnd",
                  "fontSize":11,
                  "fontFamily":"Courier New",
                  "enableBackground":true,
                  "backgroundColor":{
                     "solid":{
                        "color":"#0928DD"
                     }
                  },
                  "backgroundTransparency":30
               }
            ],
            "lineStyles":[
               {
                  "shadeArea":true,
                  "strokeWidth":4,
                  "strokeLineJoin":"bevel",
                  "showMarker":true,
                  "markerShape":"triangle",
                  "markerSize":3,
                  "markerColor":{
                     "solid":{
                        "color":"#448822"
                     }
                  }
               }
            ]
         }
      }
   }
}

 

If you have any questions, please kindly ask here and we will try to resolve it.

BTW, the JSON file as attached.    

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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