Pbir Format
- 66 installs
- 836 repo stars
- Updated July 29, 2026
- data-goblin/power-bi-agentic-development
Modify Power BI PBIR report JSON directly when the pbir CLI is unavailable, following PBIR structure and patterns and validating with jq.
About
Reference for the PBIR report JSON structure and editing patterns, used to modify report definitions directly when the pbir CLI is not available. A developer uses it to hand-edit visual and page JSON and validate each change with jq.
- Documents PBIR JSON structure for direct edits
- Fallback path when the pbir CLI is unavailable
Pbir Format by the numbers
- 66 all-time installs (skills.sh)
- Ranked #882 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-formatAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 66 |
|---|---|
| repo stars | ★ 836 |
| Last updated | July 29, 2026 |
| Repository | data-goblin/power-bi-agentic-development ↗ |
What it does
Modify Power BI PBIR report JSON directly when the pbir CLI is unavailable, following PBIR structure and patterns and validating with jq.
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