Theming - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki
The JSON definition below shows all properties of the Financial Reporting Matrix that can be themed, along with all valid values for each property.
A few things to note:
-
<empty>means empty string "" (two double quotes with no whitespace) - All colors are specified using the hex color format #XXXXXX. For example #000000 is black.
- If you import the visual from your Organizational store (not AppSource), you must change the visual id in the visualStyles section below to "financialreportingmatrixD8A502553641450F8EAEB9BA40B2166E_OrgStore"
{
"name": "Financial Reporting Matrix by Profitbase",
"dataColors": [
"#00338D",
"#005EB8",
"#0091DA",
"#483698",
"#470A68",
"#6D2077",
"#00A3A1",
"#009A44",
"#43B02A",
"#EAAA00",
"#F68D04",
"#BC204B",
"#C6007E"
],
"visualStyles": {
"financialreportingmatrixD8A502553641450F8EAEB9BA40B2166E": {
"*": {
"_fieldExamples": [{ "colorOption": { "solid": { "color": "#FF5733" } } }, { "fontFamilyOption": "Arial" }],
"customColumns": [{ "width": 100 }, { "columnSeparator": "left | right | both | <empty>" }],
"grid": [
{ "verticalGrid": false },
{ "verticalGridThickness": 1 },
{ "verticalGridColor": "" },
{ "horizontalGrid": false },
{ "horizontalGridThickness": 1 },
{ "horizontalGridColor": "" },
{ "rowPadding": 1 },
{ "fontFamily": "Segoe UI" },
{ "outlineColor": "" },
{ "outlineWeight": 1 }
],
"downloadExcel": [
{ "show": false },
{ "iconPosition": "bottom right | bottom left | top left | top right" },
{ "automaticHideIcon": false },
{ "fileSizeLimit": 10 },
{ "transparentBackground": false },
{ "showBorder": false },
{ "buttonSize": "large | middle | small" }
],
"commenting": [
{
"show": false
},
{
"iconPosition": "bottom right | bottom left | top left | top right"
},
{
"automaticHideIcon": false
},
{ "transparentBackground": false },
{ "showBorder": false },
{ "buttonSize": "large | middle | small" },
{
"dateFormat": "MM/DD/YY | YY/MM/DD | DD/MM/YY | MM/DD/YYYY | DD/MM/YYYY | YYYY/MM/DD | DD-MM-YY | DD-MM-YYYY | MM-DD-YY | MM-DD-YYYY | DD.MM.YY | DD.MM.YYYY | MM.DD.YY | MM.DD.YYYY | MM.DD.YYYY LT | YYYY.MM.DD LT | DD.MM.YYYY LT | custom"
},
{
"customDateFormat": ""
},
{
"headerTitle": "Row column | Column row | Row | Column"
},
{ "fontFamily": "Segoe UI" },
{ "fontSize": 12 },
{ "alignment": "left | center | right" }
],
"columnFormatting": [
{ "firstColumnWidth": 150 },
{ "firstColumnWidthStatic": 150 },
{ "width": 100 },
{ "columnWidthStatic": 100 },
{ "isHidden": false },
{ "applyToAllLevels": false },
{ "color": "" },
{ "backgroundColor": "" },
{ "columnBackgroundColor": "" },
{ "columnSeparatorColor": "" },
{ "separator": "<empty> | left | right | both" },
{ "formatString": "<empty> | <Power BI format string> | custom" },
{ "customFormatString": "<Power BI format string>" },
{ "alignment": "<empty> | left | right | center" }
],
"columnHeaders": [
{ "fontColor": "" },
{ "backgroundColor": "" },
{ "fontWeightBold": false },
{ "fontStyleItalic": false },
{
"outline": "<empty> | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "textSize": 8 },
{ "groupAlignment": "left | center | right" },
{ "alignment": "left | center | right" },
{ "wordWrap": true },
{ "verticalGrid": false },
{ "verticalGridColor": "" },
{ "verticalGridThickness": 1 },
{ "horizontalGrid": false },
{ "horizontalGridColor": "" },
{ "horizontalGridThickness": 1 },
{ "showPinIcon": false },
{ "enableDateFormatting": false },
{ "dateFormat": "<empty> | custom" },
{ "customDateFormat": "" }
],
"columnExpansion": [
{ "show": false },
{ "expandCollapseIconsSize": 8 },
{ "storeExpansionState": true },
{ "defaultColumnExpansion": false },
{ "expandToLevel": 1 }
],
"rowHeaders": [
{ "caption": "" },
{ "captionFontColor": "" },
{ "captionBackgroundColor": "" },
{ "captionAlignment": "left | right | center" },
{ "defaultExpandRows": false },
{ "expandToLevel": 1 },
{ "fontColor": "" },
{ "backgroundColor": "" },
{
"outline": "<empty> | bottom | bottom double | top | top right | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "textSize": 8 },
{ "alignment": "left | center | right" },
{ "dateFormat": "<empty> | custom" },
{ "customDateFormat": "" },
{ "wordWrap": true }
],
"values": [
{ "measurePlacement": "default | aboveColumns | inRows" },
{
"scalingValues": "none | thousands | millions | billions | trillions"
},
{ "negativeValueFormatting": "minus | parentheses" },
{ "zeroValueFormatting": "dash | empty | zero" },
{ "applyFormatToZeroValues": false },
{ "noValue": "zero | empty" },
{ "formatString": "<empty> | <Power BI format string> | custom" },
{ "customFormatString": "<Power BI format string>" },
{ "decimalSeparator": "." },
{ "thousandSeparator": "," },
{ "useColumnsAsMeasures": false },
{ "handlingValues": "numeric | both" },
{ "fontColor": "" },
{ "backgroundColor": "" },
{ "bandedRowStyle": false },
{ "bandedStyleForHeaderColumn": false },
{ "bandedRowFontColor": "" },
{ "bandedRowBackgroundColor": "" },
{
"outline": "none | bottom | top | left | right | top bottom | left right | top bottom left right"
},
{ "textSize": 8 },
{ "wordWrap": false }
],
"subTotals": [
{ "rowGrandTotal": false },
{ "rowGrandTotalLabel": "Total" },
{
"rowGrandTotalStyle": "\"\"| bold | overline | underline | custom1 | custom2 | custom3 | custom4 | stylesSubtotal | stylesKPI"
},
{ "rowGrandTotalPosition": "bottom | top" },
{ "freezeRowGrandTotal": false },
{ "showColumnSubtotals": false },
{ "columnSubtotalsPosition": "end | start" },
{ "columnTotalsLabel": "Total" },
{
"columnTotalsStyle": "\"\"| bold | overline | underline | custom1 | custom2 | custom3 | custom4 | stylesTotal"
},
{ "valuesTotalLabel": "{{Value}} total" },
{ "perColumnLevel": false },
{ "showRowSubtotals": false },
{ "rowTotalsLabel": "Total" },
{
"rowTotalsStyle": "\"\"| bold | overline | underline | custom1 | custom2 | custom3 | custom4 | stylesTotal"
},
{ "valuesRowTotalLabel": "{{Value}} total" },
{ "rowSubtotalsPosition": "end | start" },
{ "perRowLevel": false }
],
"rowExpansion": [
{ "storeExpansionState": true },
{ "indentSize": 10 },
{ "steppedLayout": false },
{ "showParentRowHeaderLabel": true },
{ "showParentRowHeaderLabelFromLevel": 0 },
{ "upwardsExpansion": false },
{ "useRowExpansionStyling": false },
{ "bold": false },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" },
{ "showExpandCollapseIcons": true },
{ "expandCollapseIconsSize": 8 },
{ "iconShape": "plus | triangle | arrow | diamond | square | circle" },
{ "iconColor": "" }
],
"hideEmptyRows": [
{ "show": false },
{ "alwaysShowCustomRows": true },
{ "alwaysShowJSONRows": true },
{ "hideCondition": "" }
],
"hideEmptyColumns": [{ "show": false }, { "alwaysShowCustomMeasures": true }],
"raggedHierarchy": [
{ "compressDescendants": false },
{ "hideBlanks": false },
{ "hideColumnDescendants": false },
{ "hideColumnBlanks": false }
],
"webUrl": [{ "show": false }, { "showUrlIcon": false }, { "color": "" }],
"drillDown": [{ "enableDrill": false }],
"sortBy": [
{ "show": false },
{ "iconPosition": "bottom right | bottom left | top left | top right" },
{ "automaticHideIcon": false },
{ "transparentBackground": false },
{ "showBorder": false },
{ "buttonSize": "large | middle | small" }
],
"search": [
{ "show": false },
{ "iconPosition": "bottom right | bottom left | top left | top right" },
{ "automaticHideIcon": false },
{ "transparentBackground": false },
{ "showBorder": false },
{ "buttonSize": "large | middle | small" }
],
"groupButton": [
{ "show": false },
{ "iconPosition": "bottom right | bottom left | top left | top right" },
{ "automaticHideIcon": false },
{ "transparentBackground": false },
{ "showBorder": false },
{ "buttonSize": "large | middle | small" }
],
"stylesTotal": [
{ "bold": true },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesSubtotal": [
{ "bold": true },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesKPI": [
{ "bold": true },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesCustom1": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesCustom2": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesCustom3": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesCustom4": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesCustom5": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesCustom6": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesBold": [
{ "bold": true },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesOverline": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
],
"stylesUnderline": [
{ "bold": false },
{ "fontFamily": "Segoe UI" },
{ "fontStyleItalic": false },
{ "fontSize": 8 },
{ "color": "" },
{ "background": "" },
{ "marginTop": 0 },
{ "marginBottom": 0 },
{
"outline": "\"\" | bottom | bottom double | top | top bottom | top bottom double | left | right | left right | top bottom left right"
},
{ "outlineThickness": 1 },
{ "outlineColor": "" }
]
}
}
}
}