View formattingSharePoint Online

Butterfly Chart

This sample formats a SharePoint list view into a butterfly chart.

Get this format View on GitHub

Shared by Tetsuya Kawahara
Updated Feb 5, 2021

Sample preview · View original image

Copy. Apply. Make it yours.

Get this format

1 definition

Review the requirements below, then paste this JSON into the matching formatting panel. Show me where.

Use your list's internal column names and replace any tenant-specific URLs or flow IDs. Formatting is presentation, not a way to secure data.

Definition

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "hideColumnHeader": true,
  "hideSelection": true,
  "rowFormatter": {
    "elmType": "div",
    "style": {
      "width": "90%",
      "height": "60px",
      "display": "flex",
      "flex-direction": "row",
      "margin-left": "40px",
      "margin-right": "40px"
    },
    "children": [
      {
        "elmType": "div",
        "style": {
          "width": "40%",
          "display": "flex",
          "flex-direction": "row-reverse"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "width": "= ([$Sales] / 500 * 100) + '%'",
              "height": "45px",
              "cursor": "pointer",
              "display": "flex",
              "flex-direction": "row",
              "align-items": "center"
            },
            "children": [
              {
                "elmType": "span",
                "style": {
                  "position": "relative",
                  "right": "40px"
                },
                "txtContent": "[$Sales]",
                "attributes": {
                  "class": "ms-fontSize-20"
                }
              }
            ],
            "attributes": {
              "class": "ms-bgColor-blue ms-bgColor-blueDark--hover"
            },
            "customCardProps": {
              "directionalHint": "bottomCenter",
              "isBeakVisible": true,
              "openOnEvent": "hover",
              "formatter": {
                "elmType": "div",
                "style": {
                  "width": "150px",
                  "height": "150px",
                  "display": "flex",
                  "flex-direction": "column",
                  "align-items": "center",
                  "justify-content": "center"
                },
                "children": [
                  {
                    "elmType": "div",
                    "txtContent": "[!Sales.DisplayName]",
                    "attributes": {
                      "class": "ms-fontSize-28 ms-fontColor-blue"
                    }
                  },
                  {
                    "elmType": "div",
                    "txtContent": "[$Sales]",
                    "attributes": {
                      "class": "ms-fontSize-42"
                    }
                  }
                ]
              }
            }
          }
        ]
      },
      {
        "elmType": "div",
        "txtContent": "[$Title]",
        "style": {
          "width": "20%",
          "height": "100%",
          "border-left": "2px solid",
          "border-right": "2px solid",
          "display": "flex",
          "align-items": "center",
          "justify-content": "center",
          "padding": "5px"
        },
        "attributes": {
          "class": "ms-fontSize-28"
        }
      },
      {
        "elmType": "div",
        "style": {
          "width": "40%",
          "display": "flex",
          "flex-direction": "row"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "width": "= ([$Cost] / 500 * 100) + '%'",
              "height": "45px",
              "cursor": "pointer",
              "display": "flex",
              "flex-direction": "row-reverse",
              "align-items": "center"
            },
            "children": [
              {
                "elmType": "span",
                "style": {
                  "position": "relative",
                  "left": "40px"
                },
                "txtContent": "[$Cost]",
                "attributes": {
                  "class": "ms-fontSize-20"
                }
              }
            ],
            "attributes": {
              "class": "ms-bgColor-red ms-bgColor-redDark--hover"
            },
            "customCardProps": {
              "directionalHint": "bottomCenter",
              "isBeakVisible": true,
              "openOnEvent": "hover",
              "formatter": {
                "elmType": "div",
                "style": {
                  "width": "150px",
                  "height": "150px",
                  "display": "flex",
                  "flex-direction": "column",
                  "align-items": "center",
                  "justify-content": "center"
                },
                "children": [
                  {
                    "elmType": "div",
                    "txtContent": "[!Cost.DisplayName]",
                    "attributes": {
                      "class": "ms-fontSize-28 ms-fontColor-red"
                    }
                  },
                  {
                    "elmType": "div",
                    "txtContent": "[$Cost]",
                    "attributes": {
                      "class": "ms-fontSize-42"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    ]
  }
}

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json",
  "hideColumnHeader": true,
  "hideSelection": true,
  "rowFormatter": {
    "elmType": "div",
    "style": {
      "width": "90%",
      "height": "60px",
      "display": "flex",
      "flex-direction": "row",
      "margin-left": "40px",
      "margin-right": "40px"
    },
    "children": [
      {
        "elmType": "div",
        "style": {
          "width": "40%",
          "display": "flex",
          "flex-direction": "row-reverse"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "width": "= ([$Sales] / 500 * 100) + '%'",
              "height": "45px",
              "cursor": "pointer",
              "display": "flex",
              "flex-direction": "row",
              "align-items": "center"
            },
            "children": [
              {
                "elmType": "span",
                "style": {
                  "position": "relative",
                  "right": "40px"
                },
                "txtContent": "[$Sales]",
                "attributes": {
                  "class": "ms-fontSize-20"
                }
              }
            ],
            "attributes": {
              "class": "ms-bgColor-blue ms-bgColor-blueDark--hover"
            },
            "customCardProps": {
              "directionalHint": "bottomCenter",
              "isBeakVisible": true,
              "openOnEvent": "hover",
              "formatter": {
                "elmType": "div",
                "style": {
                  "width": "150px",
                  "height": "150px",
                  "display": "flex",
                  "flex-direction": "column",
                  "align-items": "center",
                  "justify-content": "center"
                },
                "children": [
                  {
                    "elmType": "div",
                    "txtContent": "[!Sales.DisplayName]",
                    "attributes": {
                      "class": "ms-fontSize-28 ms-fontColor-blue"
                    }
                  },
                  {
                    "elmType": "div",
                    "txtContent": "[$Sales]",
                    "attributes": {
                      "class": "ms-fontSize-42"
                    }
                  }
                ]
              }
            }
          }
        ]
      },
      {
        "elmType": "div",
        "txtContent": "[$Title]",
        "style": {
          "width": "20%",
          "height": "100%",
          "border-left": "2px solid",
          "border-right": "2px solid",
          "display": "flex",
          "align-items": "center",
          "justify-content": "center",
          "padding": "5px"
        },
        "attributes": {
          "class": "ms-fontSize-28"
        }
      },
      {
        "elmType": "div",
        "style": {
          "width": "40%",
          "display": "flex",
          "flex-direction": "row"
        },
        "children": [
          {
            "elmType": "div",
            "style": {
              "width": "= ([$Cost] / 500 * 100) + '%'",
              "height": "45px",
              "cursor": "pointer",
              "display": "flex",
              "flex-direction": "row-reverse",
              "align-items": "center"
            },
            "children": [
              {
                "elmType": "span",
                "style": {
                  "position": "relative",
                  "left": "40px"
                },
                "txtContent": "[$Cost]",
                "attributes": {
                  "class": "ms-fontSize-20"
                }
              }
            ],
            "attributes": {
              "class": "ms-bgColor-red ms-bgColor-redDark--hover"
            },
            "customCardProps": {
              "directionalHint": "bottomCenter",
              "isBeakVisible": true,
              "openOnEvent": "hover",
              "formatter": {
                "elmType": "div",
                "style": {
                  "width": "150px",
                  "height": "150px",
                  "display": "flex",
                  "flex-direction": "column",
                  "align-items": "center",
                  "justify-content": "center"
                },
                "children": [
                  {
                    "elmType": "div",
                    "txtContent": "[!Cost.DisplayName]",
                    "attributes": {
                      "class": "ms-fontSize-28 ms-fontColor-red"
                    }
                  },
                  {
                    "elmType": "div",
                    "txtContent": "[$Cost]",
                    "attributes": {
                      "class": "ms-fontSize-42"
                    }
                  }
                ]
              }
            }
          }
        ]
      }
    ]
  }
}

.definition[hidden] { display:block !important; } .variant-chooser,[data-copy] { display:none; }All definitions are shown below. Select the code manually or download the JSON file.

From the contributor

How to use this sample

Summary

This sample formats a SharePoint list view into a butterfly chart.

screenshot of the sample

This example shows values from 0 to 500. You can adjust this scale by changing the width value of the style element.

View requirements

Type	Internal Name	Required
Single line of text	Title	Yes
Number	Sales	Yes
Number	Cost	Yes

Sample

Solution	Author(s)
butterfly-chart.json	Tetsuya Kawahara

Version history

Version	Date	Comments
1.0	February 5, 2021	Initial release
2.0	August 20, 2021	Screenshot added

Disclaimer

THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.

Get this format

How to use this sample

Summary

View requirements

Sample

Version history

Disclaimer

More formats like this

Key Dates Timeline Checklist

Bar Chart Diagram

Image Grid