Pbir Cli
- 53 installs
- 836 repo stars
- Updated July 29, 2026
- data-goblin/power-bi-agentic-development
Use the pbir CLI to author and modify Power BI PBIR report definitions, editing pages, visuals, and formatting from the terminal.
About
Command reference for the pbir CLI that authors and edits Power BI PBIR report JSON from the terminal. A developer uses it as the preferred tool to add pages, place and bind visuals, and apply formatting to a report.
- Edits PBIR report definitions via the pbir command
- Preferred tool for adding pages, visuals, and formatting
Pbir Cli by the numbers
- 53 all-time installs (skills.sh)
- Ranked #916 of 2,064 Data Science & ML skills by installs in the Skillselion catalog
- Data as of Aug 5, 2026 (Skillselion catalog sync)
npx skills add https://github.com/data-goblin/power-bi-agentic-development --skill pbir-cliAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 53 |
|---|---|
| repo stars | ★ 836 |
| Last updated | July 29, 2026 |
| Repository | data-goblin/power-bi-agentic-development ↗ |
What it does
Use the pbir CLI to author and modify Power BI PBIR report definitions, editing pages, visuals, and formatting from the terminal.
Files
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/gitIntegration/platformProperties/2.0.0/schema.json",
"metadata": {
"type": "Report",
"displayName": "K201 - MonthSlicer"
},
"config": {
"version": "2.0",
"logicalId": "1b2a96e3-19f0-4ace-a2b9-55decaf15cb3"
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definitionProperties/2.0.0/schema.json",
"version": "4.0",
"datasetReference": {
"byConnection": {
"connectionString": "Data Source=\"powerbi://api.powerbi.com/v1.0/myorg/Report Templates [DEV]\";initial catalog=\"K201 - MonthSlicer\";access mode=readonly;integrated security=ClaimsToken;semanticmodelid=1312c750-c4a1-406b-9e54-89809107a1a2"
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/bookmark/1.4.0/schema.json",
"displayName": "hide stuff",
"name": "54698b9cd0a0c57906b7",
"options": {
"targetVisualNames": []
},
"explorationState": {
"version": "1.3",
"activeSection": "56bda0fdb3f32a7d1fe9",
"filters": {
"byExpr": [
{
"name": "500061d160e87b50a006",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 1
},
{
"name": "d3f20cea05c37b47123a",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "e",
"Entity": "Exchange Rate",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "e"
}
},
"Property": "From Currency"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'EUR'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Exchange Rate"
}
},
"Property": "From Currency"
}
},
"howCreated": 1
},
{
"name": "9a135e8e175961ab0070",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Year (ie 2021)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'2022'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 1
},
{
"name": "0a0567e84b620b8bde0d",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "1",
"Entity": "1) Selected Metric",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "1"
}
},
"Property": "Select a Measure"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Gross Sales'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "1) Selected Metric"
}
},
"Property": "Select a Measure"
}
},
"howCreated": 1
},
{
"name": "5d400a092d70d60100d1",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "3",
"Entity": "3) Selected Target",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "3"
}
},
"Property": "Select a Target"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'1 Year Prior'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "3) Selected Target"
}
},
"Property": "Select a Target"
}
},
"howCreated": 1
},
{
"name": "3f0414e5b8619184a05e",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "2",
"Entity": "2) Selected Unit",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "2"
}
},
"Property": "Select a Unit"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Value (Budget Rate)'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "2) Selected Unit"
}
},
"Property": "Select a Unit"
}
},
"howCreated": 1
},
{
"name": "61fce691ed537b989b43",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "b",
"Entity": "Brands",
"Type": 0
}
],
"Where": [
{
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "b"
}
},
"Property": "Brand"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'ASAN'"
}
}
],
[
{
"Literal": {
"Value": "'Galileo'"
}
}
],
[
{
"Literal": {
"Value": "'Miller'"
}
}
],
[
{
"Literal": {
"Value": "'Newton'"
}
}
],
[
{
"Literal": {
"Value": "'Plasma'"
}
}
],
[
{
"Literal": {
"Value": "'TH Morgan'"
}
}
],
[
{
"Literal": {
"Value": "'Volcanic'"
}
}
],
[
{
"Literal": {
"Value": "'Roemon'"
}
}
]
]
}
}
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Brands"
}
},
"Property": "Brand"
}
},
"howCreated": 1
}
]
},
"sections": {
"da2e63ebeb2179a994f1": {
"visualContainers": {
"d1659b2e03dd55982c91": {
"filters": {
"byExpr": [
{
"name": "6a07732fb005296008d0",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "advancedSlicerVisual",
"objects": {
"merge": {
"general": [
{
"properties": {
"filter": {
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Aug'"
}
}
]
]
}
}
}
]
}
}
}
}
]
}
},
"display": {
"mode": "hidden"
}
}
},
"34d999b937f71aa86cd1": {
"filters": {
"byExpr": [
{
"name": "f771b5dc5b6a775ebce9",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
},
{
"name": "ae02dd4ca8504c18c575",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "64d991055b595a1552da",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "kpi",
"objects": {}
}
},
"34fbad854de667f3f03a": {
"filters": {
"byExpr": [
{
"name": "a3bc763d53919bb79661",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
},
{
"name": "0d0331893332ad8a5c84",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "263fae60cd4002931c3d",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "lineChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
]
}
}
},
"0beb3f5ca29d448bda58": {
"filters": {
"byExpr": [
{
"name": "8477fa724aeb34b1c451",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
},
"howCreated": 0
},
{
"name": "7f1e6285864e0c43e006",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Value"
}
},
"howCreated": 0
},
{
"name": "ae5015123044cd149065",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Quantity"
}
},
"howCreated": 0
},
{
"name": "2045f62fb16055c304ad",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "84b900c509e0111189c6",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "scatterChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
}
],
"X": [
{
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
]
}
}
},
"e0287d9bf5434b6e4daa": {
"singleVisual": {
"visualType": "textbox",
"objects": {}
}
},
"b53565edbb3536d72bfc": {
"filters": {
"byExpr": [
{
"name": "cad4501da5bd7122aea1",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"howCreated": 0
},
{
"name": "f704a17b313705050689",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "19b60afb03eac1083012",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "New SVG Bullet Chart (with Action Dots) 1"
}
},
"howCreated": 0
},
{
"name": "999e20e1ece493ecbe8e",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "1) Selected Metric"
}
},
"Property": "Late Orders"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "tableEx",
"objects": {},
"orderBy": [
{
"Direction": 1,
"Expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
}
],
"display": {
"mode": "hidden"
}
}
}
}
}
},
"objects": {
"merge": {
"outspacePane": [
{
"properties": {
"expanded": {
"expr": {
"Literal": {
"Value": "false"
}
}
}
}
}
]
}
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/bookmark/1.4.0/schema.json",
"displayName": "current page unselected",
"name": "71abeb475381792b035d",
"options": {
"targetVisualNames": [
"b53565edbb3536d72bfc"
],
"suppressActiveSection": true
},
"explorationState": {
"version": "1.3",
"activeSection": "56bda0fdb3f32a7d1fe9",
"filters": {
"byExpr": [
{
"name": "500061d160e87b50a006",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 1
},
{
"name": "d3f20cea05c37b47123a",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "e",
"Entity": "Exchange Rate",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "e"
}
},
"Property": "From Currency"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'EUR'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Exchange Rate"
}
},
"Property": "From Currency"
}
},
"howCreated": 1
},
{
"name": "9a135e8e175961ab0070",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Year (ie 2021)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'2022'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 1
},
{
"name": "0a0567e84b620b8bde0d",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "1",
"Entity": "1) Selected Metric",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "1"
}
},
"Property": "Select a Measure"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Gross Sales'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "1) Selected Metric"
}
},
"Property": "Select a Measure"
}
},
"howCreated": 1
},
{
"name": "5d400a092d70d60100d1",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "3",
"Entity": "3) Selected Target",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "3"
}
},
"Property": "Select a Target"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'1 Year Prior'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "3) Selected Target"
}
},
"Property": "Select a Target"
}
},
"howCreated": 1
},
{
"name": "3f0414e5b8619184a05e",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "2",
"Entity": "2) Selected Unit",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "2"
}
},
"Property": "Select a Unit"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Value (Budget Rate)'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "2) Selected Unit"
}
},
"Property": "Select a Unit"
}
},
"howCreated": 1
},
{
"name": "61fce691ed537b989b43",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "b",
"Entity": "Brands",
"Type": 0
}
],
"Where": [
{
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "b"
}
},
"Property": "Brand"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'ASAN'"
}
}
],
[
{
"Literal": {
"Value": "'Galileo'"
}
}
],
[
{
"Literal": {
"Value": "'Miller'"
}
}
],
[
{
"Literal": {
"Value": "'Newton'"
}
}
],
[
{
"Literal": {
"Value": "'Plasma'"
}
}
],
[
{
"Literal": {
"Value": "'TH Morgan'"
}
}
],
[
{
"Literal": {
"Value": "'Volcanic'"
}
}
],
[
{
"Literal": {
"Value": "'Roemon'"
}
}
]
]
}
}
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Brands"
}
},
"Property": "Brand"
}
},
"howCreated": 1
}
]
},
"sections": {
"da2e63ebeb2179a994f1": {
"visualContainers": {
"d1659b2e03dd55982c91": {
"filters": {
"byExpr": [
{
"name": "06918ef52ebd447815b0",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "advancedSlicerVisual",
"objects": {
"merge": {
"general": [
{
"properties": {
"filter": {
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Aug'"
}
}
]
]
}
}
}
]
}
}
}
}
]
}
}
}
},
"34d999b937f71aa86cd1": {
"filters": {
"byExpr": [
{
"name": "f33f83d82307c110d39c",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
},
{
"name": "661d32911b1839177b10",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "13eb51ed54600c04dd61",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "kpi",
"objects": {}
}
},
"34fbad854de667f3f03a": {
"filters": {
"byExpr": [
{
"name": "50277817090880be5408",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
},
{
"name": "21d5cba066d1dc303bb6",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "2a3a49861c114d3b8647",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "lineChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
]
}
}
},
"0beb3f5ca29d448bda58": {
"filters": {
"byExpr": [
{
"name": "e1ffd483156021cad2e9",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
},
"howCreated": 0
},
{
"name": "2006f8fddd5c4e097aa0",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Value"
}
},
"howCreated": 0
},
{
"name": "1d0978722dc9d180951b",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Quantity"
}
},
"howCreated": 0
},
{
"name": "58962313ab0e5ca03619",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "9b39ee014573607eab3b",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "scatterChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
}
],
"X": [
{
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
]
}
}
},
"e0287d9bf5434b6e4daa": {
"singleVisual": {
"visualType": "textbox",
"objects": {}
}
},
"b53565edbb3536d72bfc": {
"filters": {
"byExpr": [
{
"name": "4179db559050127b2b84",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"howCreated": 0
},
{
"name": "8772daf749251e00a412",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "3acd0e6523d78693abc9",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "New SVG Bullet Chart (with Action Dots) 1"
}
},
"howCreated": 0
},
{
"name": "36f5e527ed60301cb376",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "1) Selected Metric"
}
},
"Property": "Late Orders"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "tableEx",
"objects": {},
"orderBy": [
{
"Direction": 1,
"Expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
}
]
},
"highlight": {
"selection": [
{
"dataMap": {
"Customers.Key Account Name": [
{
"scopeId": {
"Comparison": {
"ComparisonKind": 0,
"Left": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"Right": {
"Literal": {
"Value": "'Andromeda Shipyards'"
}
}
}
}
}
]
},
"metadata": [
"On-Time Delivery.OTD % (Value)",
"On-Time Delivery.New SVG Bullet Chart (with Action Dots) 1",
"1) Selected Metric.Late Orders"
]
}
],
"filterExpressionMetadata": {
"expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
}
],
"cachedValueItems": [
{
"identities": [
{
"scopeId": {
"Comparison": {
"ComparisonKind": 0,
"Left": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"Right": {
"Literal": {
"Value": "'Andromeda Shipyards'"
}
}
}
}
}
],
"valueMap": {
"0": "Andromeda Shipyards"
}
}
]
}
}
}
}
}
},
"objects": {
"merge": {
"outspacePane": [
{
"properties": {
"expanded": {
"expr": {
"Literal": {
"Value": "false"
}
}
}
}
}
]
}
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/bookmark/1.4.0/schema.json",
"displayName": "display unselected",
"name": "82ce9a7f49847d03190a",
"options": {
"targetVisualNames": [
"d1659b2e03dd55982c91"
],
"suppressDisplay": true
},
"explorationState": {
"version": "1.3",
"activeSection": "56bda0fdb3f32a7d1fe9",
"filters": {
"byExpr": [
{
"name": "500061d160e87b50a006",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 1
},
{
"name": "d3f20cea05c37b47123a",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "e",
"Entity": "Exchange Rate",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "e"
}
},
"Property": "From Currency"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'EUR'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Exchange Rate"
}
},
"Property": "From Currency"
}
},
"howCreated": 1
},
{
"name": "9a135e8e175961ab0070",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Year (ie 2021)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'2022'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 1
},
{
"name": "0a0567e84b620b8bde0d",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "1",
"Entity": "1) Selected Metric",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "1"
}
},
"Property": "Select a Measure"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Gross Sales'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "1) Selected Metric"
}
},
"Property": "Select a Measure"
}
},
"howCreated": 1
},
{
"name": "5d400a092d70d60100d1",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "3",
"Entity": "3) Selected Target",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "3"
}
},
"Property": "Select a Target"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'1 Year Prior'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "3) Selected Target"
}
},
"Property": "Select a Target"
}
},
"howCreated": 1
},
{
"name": "3f0414e5b8619184a05e",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "2",
"Entity": "2) Selected Unit",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "2"
}
},
"Property": "Select a Unit"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Value (Budget Rate)'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "2) Selected Unit"
}
},
"Property": "Select a Unit"
}
},
"howCreated": 1
},
{
"name": "61fce691ed537b989b43",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "b",
"Entity": "Brands",
"Type": 0
}
],
"Where": [
{
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "b"
}
},
"Property": "Brand"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'ASAN'"
}
}
],
[
{
"Literal": {
"Value": "'Galileo'"
}
}
],
[
{
"Literal": {
"Value": "'Miller'"
}
}
],
[
{
"Literal": {
"Value": "'Newton'"
}
}
],
[
{
"Literal": {
"Value": "'Plasma'"
}
}
],
[
{
"Literal": {
"Value": "'TH Morgan'"
}
}
],
[
{
"Literal": {
"Value": "'Volcanic'"
}
}
],
[
{
"Literal": {
"Value": "'Roemon'"
}
}
]
]
}
}
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Brands"
}
},
"Property": "Brand"
}
},
"howCreated": 1
}
]
},
"sections": {
"da2e63ebeb2179a994f1": {
"visualContainers": {
"d1659b2e03dd55982c91": {
"filters": {
"byExpr": [
{
"name": "2861561e26adac7a1630",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "advancedSlicerVisual",
"objects": {
"merge": {
"general": [
{
"properties": {
"filter": {
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Mar'"
}
}
]
]
}
}
}
]
}
}
}
}
]
}
}
}
},
"34d999b937f71aa86cd1": {
"filters": {
"byExpr": [
{
"name": "d8bd67a43e0d88160d6c",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
},
{
"name": "433e8b50be70ca3cd1e2",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "381d3db2c0da47812ae8",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "kpi",
"objects": {}
}
},
"34fbad854de667f3f03a": {
"filters": {
"byExpr": [
{
"name": "8bbdae5043dcee7e7377",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
},
{
"name": "90556d15e30808c9c69b",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "7d1f30c15005b35d5cb6",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "lineChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
]
}
}
},
"0beb3f5ca29d448bda58": {
"filters": {
"byExpr": [
{
"name": "137d9f3152e35b237c9a",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
},
"howCreated": 0
},
{
"name": "528c9f3bcb99db6a1a91",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Value"
}
},
"howCreated": 0
},
{
"name": "e064bd480c9977a10d24",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Quantity"
}
},
"howCreated": 0
},
{
"name": "308ab06bb0304520d246",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "3fe2616203054d56b9cd",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "scatterChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
}
],
"X": [
{
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
]
}
}
},
"e0287d9bf5434b6e4daa": {
"singleVisual": {
"visualType": "textbox",
"objects": {}
}
},
"b53565edbb3536d72bfc": {
"filters": {
"byExpr": [
{
"name": "5829d7072536394d93e5",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"howCreated": 0
},
{
"name": "f2755907b5e82407b80b",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "ad9d301f24115eb90851",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "New SVG Bullet Chart (with Action Dots) 1"
}
},
"howCreated": 0
},
{
"name": "0a7dba688b1b8164c7ad",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "1) Selected Metric"
}
},
"Property": "Late Orders"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "tableEx",
"objects": {},
"orderBy": [
{
"Direction": 1,
"Expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
}
]
}
}
}
}
},
"objects": {
"merge": {
"outspacePane": [
{
"properties": {
"expanded": {
"expr": {
"Literal": {
"Value": "false"
}
}
}
}
}
]
}
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/bookmark/1.4.0/schema.json",
"displayName": "only applied to one visual",
"name": "8f5a4883bde0d3bd075d",
"options": {
"applyOnlyToTargetVisuals": true,
"targetVisualNames": [
"d1659b2e03dd55982c91"
]
},
"explorationState": {
"version": "1.3",
"activeSection": "56bda0fdb3f32a7d1fe9",
"filters": {
"byExpr": [
{
"name": "500061d160e87b50a006",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 1
},
{
"name": "d3f20cea05c37b47123a",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "e",
"Entity": "Exchange Rate",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "e"
}
},
"Property": "From Currency"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'EUR'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Exchange Rate"
}
},
"Property": "From Currency"
}
},
"howCreated": 1
},
{
"name": "9a135e8e175961ab0070",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Year (ie 2021)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'2022'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 1
},
{
"name": "0a0567e84b620b8bde0d",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "1",
"Entity": "1) Selected Metric",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "1"
}
},
"Property": "Select a Measure"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Gross Sales'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "1) Selected Metric"
}
},
"Property": "Select a Measure"
}
},
"howCreated": 1
},
{
"name": "5d400a092d70d60100d1",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "3",
"Entity": "3) Selected Target",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "3"
}
},
"Property": "Select a Target"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'1 Year Prior'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "3) Selected Target"
}
},
"Property": "Select a Target"
}
},
"howCreated": 1
},
{
"name": "3f0414e5b8619184a05e",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "2",
"Entity": "2) Selected Unit",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "2"
}
},
"Property": "Select a Unit"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Value (Budget Rate)'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "2) Selected Unit"
}
},
"Property": "Select a Unit"
}
},
"howCreated": 1
},
{
"name": "61fce691ed537b989b43",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "b",
"Entity": "Brands",
"Type": 0
}
],
"Where": [
{
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "b"
}
},
"Property": "Brand"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'ASAN'"
}
}
],
[
{
"Literal": {
"Value": "'Galileo'"
}
}
],
[
{
"Literal": {
"Value": "'Miller'"
}
}
],
[
{
"Literal": {
"Value": "'Newton'"
}
}
],
[
{
"Literal": {
"Value": "'Plasma'"
}
}
],
[
{
"Literal": {
"Value": "'TH Morgan'"
}
}
],
[
{
"Literal": {
"Value": "'Volcanic'"
}
}
],
[
{
"Literal": {
"Value": "'Roemon'"
}
}
]
]
}
}
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Brands"
}
},
"Property": "Brand"
}
},
"howCreated": 1
}
]
},
"sections": {
"da2e63ebeb2179a994f1": {
"visualContainers": {
"d1659b2e03dd55982c91": {
"filters": {
"byExpr": [
{
"name": "282b172307554a3c7788",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "advancedSlicerVisual",
"objects": {
"merge": {
"general": [
{
"properties": {
"filter": {
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Sep'"
}
}
]
]
}
}
}
]
}
}
}
}
]
}
}
}
},
"34d999b937f71aa86cd1": {
"filters": {
"byExpr": [
{
"name": "c143fa6b51d3c005b284",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
},
{
"name": "50fadf0e9dd82dccdcac",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "611834bf092a9a499727",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "kpi",
"objects": {}
}
},
"34fbad854de667f3f03a": {
"filters": {
"byExpr": [
{
"name": "956cc4eee01a20b78903",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
},
{
"name": "33e72106e76e0953763b",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "9cbb74afa88230918570",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "lineChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
]
}
}
},
"0beb3f5ca29d448bda58": {
"filters": {
"byExpr": [
{
"name": "c050fa23c071a46434e8",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
},
"howCreated": 0
},
{
"name": "a52d45a8300ece0e0526",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Value"
}
},
"howCreated": 0
},
{
"name": "c5a9ed1d59103d560007",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Quantity"
}
},
"howCreated": 0
},
{
"name": "00ea723e22c27c06ba68",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "42246f203a1766713815",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "scatterChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
}
],
"X": [
{
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
]
}
}
},
"e0287d9bf5434b6e4daa": {
"singleVisual": {
"visualType": "textbox",
"objects": {}
}
},
"b53565edbb3536d72bfc": {
"filters": {
"byExpr": [
{
"name": "657a19145ea125ce91d3",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"howCreated": 0
},
{
"name": "9bdb29273ed32aec5353",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "bad907a11062343b853e",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "New SVG Bullet Chart (with Action Dots) 1"
}
},
"howCreated": 0
},
{
"name": "125cc0025a82c133eaec",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "1) Selected Metric"
}
},
"Property": "Late Orders"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "tableEx",
"objects": {},
"orderBy": [
{
"Direction": 1,
"Expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
}
]
}
}
}
}
},
"objects": {
"merge": {
"outspacePane": [
{
"properties": {
"expanded": {
"expr": {
"Literal": {
"Value": "false"
}
}
}
}
}
]
}
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/bookmark/1.4.0/schema.json",
"displayName": "default",
"name": "958f29ad733c047ee0b8",
"options": {
"targetVisualNames": []
},
"explorationState": {
"version": "1.3",
"activeSection": "56bda0fdb3f32a7d1fe9",
"filters": {
"byExpr": [
{
"name": "500061d160e87b50a006",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 1
},
{
"name": "d3f20cea05c37b47123a",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "e",
"Entity": "Exchange Rate",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "e"
}
},
"Property": "From Currency"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'EUR'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Exchange Rate"
}
},
"Property": "From Currency"
}
},
"howCreated": 1
},
{
"name": "9a135e8e175961ab0070",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Year (ie 2021)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'2022'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 1
},
{
"name": "0a0567e84b620b8bde0d",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "1",
"Entity": "1) Selected Metric",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "1"
}
},
"Property": "Select a Measure"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Gross Sales'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "1) Selected Metric"
}
},
"Property": "Select a Measure"
}
},
"howCreated": 1
},
{
"name": "5d400a092d70d60100d1",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "3",
"Entity": "3) Selected Target",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "3"
}
},
"Property": "Select a Target"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'1 Year Prior'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "3) Selected Target"
}
},
"Property": "Select a Target"
}
},
"howCreated": 1
},
{
"name": "3f0414e5b8619184a05e",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "2",
"Entity": "2) Selected Unit",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "2"
}
},
"Property": "Select a Unit"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Value (Budget Rate)'"
}
}
]
]
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "2) Selected Unit"
}
},
"Property": "Select a Unit"
}
},
"howCreated": 1
},
{
"name": "61fce691ed537b989b43",
"type": "Categorical",
"filter": {
"Version": 2,
"From": [
{
"Name": "b",
"Entity": "Brands",
"Type": 0
}
],
"Where": [
{
"Condition": {
"Not": {
"Expression": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "b"
}
},
"Property": "Brand"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'ASAN'"
}
}
],
[
{
"Literal": {
"Value": "'Galileo'"
}
}
],
[
{
"Literal": {
"Value": "'Miller'"
}
}
],
[
{
"Literal": {
"Value": "'Newton'"
}
}
],
[
{
"Literal": {
"Value": "'Plasma'"
}
}
],
[
{
"Literal": {
"Value": "'TH Morgan'"
}
}
],
[
{
"Literal": {
"Value": "'Volcanic'"
}
}
],
[
{
"Literal": {
"Value": "'Roemon'"
}
}
]
]
}
}
}
}
}
]
},
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Brands"
}
},
"Property": "Brand"
}
},
"howCreated": 1
}
]
},
"sections": {
"da2e63ebeb2179a994f1": {
"visualContainers": {
"d1659b2e03dd55982c91": {
"filters": {
"byExpr": [
{
"name": "f4b30f4146a079ddd459",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "advancedSlicerVisual",
"objects": {
"merge": {
"general": [
{
"properties": {
"filter": {
"filter": {
"Version": 2,
"From": [
{
"Name": "d",
"Entity": "Date",
"Type": 0
}
],
"Where": [
{
"Condition": {
"In": {
"Expressions": [
{
"Column": {
"Expression": {
"SourceRef": {
"Source": "d"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
],
"Values": [
[
{
"Literal": {
"Value": "'Aug'"
}
}
]
]
}
}
}
]
}
}
}
}
]
}
}
}
},
"34d999b937f71aa86cd1": {
"filters": {
"byExpr": [
{
"name": "e1be985237a5b03a720a",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
},
{
"name": "dcfa761bb4e07d3700b4",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "cdcb60ed728940d57207",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Year (ie 2021)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "kpi",
"objects": {}
}
},
"34fbad854de667f3f03a": {
"filters": {
"byExpr": [
{
"name": "c2a4682fbe4619bb08a9",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
},
"howCreated": 0
},
{
"name": "3e73c5385353793e0557",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "a81ab329030554524904",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "lineChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Date"
}
},
"Property": "Calendar Month (ie Jan)"
}
}
]
}
}
},
"0beb3f5ca29d448bda58": {
"filters": {
"byExpr": [
{
"name": "a07d79e7b5b9c1697a15",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
},
"howCreated": 0
},
{
"name": "0aaadd74633290065481",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Value"
}
},
"howCreated": 0
},
{
"name": "815dd0b688215eb4e903",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "Orders"
}
},
"Property": "Total Net Order Quantity"
}
},
"howCreated": 0
},
{
"name": "1918976082218b8bb0c9",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "c37a12ec0518a5521ad1",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value; PY REPT)"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "scatterChart",
"objects": {},
"activeProjections": {
"Category": [
{
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Products"
}
},
"Property": "Product Name"
}
}
],
"X": [
{
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
]
}
}
},
"e0287d9bf5434b6e4daa": {
"singleVisual": {
"visualType": "textbox",
"objects": {}
}
},
"b53565edbb3536d72bfc": {
"filters": {
"byExpr": [
{
"name": "8fbfd8550311e71e30bc",
"type": "Categorical",
"expression": {
"Column": {
"Expression": {
"SourceRef": {
"Entity": "Customers"
}
},
"Property": "Key Account Name"
}
},
"howCreated": 0
},
{
"name": "a0e132d930ba09420d03",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
},
"howCreated": 0
},
{
"name": "3f56a470bb3180d879d3",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "New SVG Bullet Chart (with Action Dots) 1"
}
},
"howCreated": 0
},
{
"name": "297ab7550c589649ec32",
"type": "Advanced",
"expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Schema": "extension",
"Entity": "1) Selected Metric"
}
},
"Property": "Late Orders"
}
},
"howCreated": 0
}
]
},
"singleVisual": {
"visualType": "tableEx",
"objects": {},
"orderBy": [
{
"Direction": 1,
"Expression": {
"Measure": {
"Expression": {
"SourceRef": {
"Entity": "On-Time Delivery"
}
},
"Property": "OTD % (Value)"
}
}
}
]
}
}
}
}
},
"objects": {
"merge": {
"outspacePane": [
{
"properties": {
"expanded": {
"expr": {
"Literal": {
"Value": "false"
}
}
}
}
}
]
}
}
}
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/bookmarksMetadata/1.0.0/schema.json",
"items": [
{
"name": "958f29ad733c047ee0b8"
},
{
"name": "54698b9cd0a0c57906b7"
},
{
"name": "71abeb475381792b035d"
},
{
"name": "e5b8aa0b8e0565be9ce0"
},
{
"name": "82ce9a7f49847d03190a"
},
{
"name": "8f5a4883bde0d3bd075d"
}
]
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/page/2.0.0/schema.json",
"name": "56bda0fdb3f32a7d1fe9",
"displayName": "Before Report",
"displayOption": "FitToPage",
"height": 720,
"width": 1280,
"visualInteractions": [
{
"source": "253cea9f56d316ec7291",
"target": "ed8b8152417decb421f8",
"type": "NoFilter"
}
]
}
{
"$schema": "https://developer.microsoft.com/json-schemas/fabric/item/report/definition/pagesMetadata/1.0.0/schema.json",
"pageOrder": [
"56bda0fdb3f32a7d1fe9",
"5b9de88f152744001bbe"
],
"activePageName": "56bda0fdb3f32a7d1fe9"
}
Related skills
Microsoft FoundryDeploy, evaluate, and continuously improve Microsoft Foundry agents from a single agent interface.490k1.3k
Ai Research ReproductionOrchestrate trustworthy, auditable reproduction of deep learning repositories directly from their READMEs.176k511Run TrainSafely execute selected deep learning training commands with standardized evidence capture.176k511Explore RunSafely run isolated exploratory experiments with clear recording and conservative selection before committing changes.176k511Paper Context ResolverFetch precise reproduction-critical details like dataset splits, preprocessing steps, or evaluation protocols from the original academic paper when the repo README leav141k511Repo Intake And PlanScan unfamiliar AI research repositories and receive a minimal, trustworthy reproduction target before investing significant time.140k511Data Science & MLanalytics