| Location: | Local or Network Folders |
| Host: | FINDITEZ-X1GEN2 |
| Path: | C:\Users\kgnazdowsky\Documents\Find IT EZ Docs\Test Cases\PowerBI\Store Sales.pbix |
Report Layout
Page Name "Store Sales Overview"
Visuals
Visualization "6c7a7c574d6b02dc3555"
Type "actionButton"
Properties
icon
shapeType "'qna'"
horizontalAlignment "'center'"
lineWeight "2L"
leftMargin "9L"
rightMargin "9L"
topMargin "9L"
bottomMargin "9L"
lineWeight "0L"
outline
show "false"
text
show "true"
text "'Q&A'"
horizontalAlignment "'center'"
fill
show "true"
transparency "0D"
Visualization "a79a49d01c0d120554ee"
Type "textbox"
Properties
general
paragraphs "STORE SALES"" REPORT"" ""Store Sales Overview"
Visualization "8611c361d6d685e80665"
Type "lineClusteredColumnComboChart"
Filters
Datasource Filter SELECT
"FiscalMonth"
,"This Year Sales"
,"Total Sales Var %"
FROM
"t"."Time"
,"s"."Sales"
ORDER BY
"FiscalMonth" ASC
,"FiscalMonth" ASC
Fields
Axis "FiscalMonth"
Value "This Year Sales"
Properties
categoryAxis
axisType "'Categorical'"
labels
show "false"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
Visualization "b75483a790029dd4a1c6"
Type "scatterChart"
Filters
"Categorical" Filter "Store Type" = "'Same Store'"
Datasource Filter SELECT
"District"
,"StoreNumber"
,"Sales Per Sq Ft"
,"This Year Sales"
,"Total Sales Var %"
FROM
"d"."District"
,"s"."Store"
,"s1"."Sales"
WHERE
"Store Type" = "'Same Store'"
Fields
Axis "District"
"StoreNumber"
Value "Total Sales Var %"
"Sales Per Sq Ft"
Size "This Year Sales"
Properties
categoryAxis
axisType "'Categorical'"
categoryLabels
show "true"
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
colorBorder
show "true"
Visualization "8e0f98274cab22c6a80e"
Type "pieChart"
Filters
Datasource Filter SELECT
"Chain"
,"This Year Sales"
FROM
"s"."Store"
,"s1"."Sales"
Fields
Axis "Chain"
Value "This Year Sales"
Properties
labels
show "true"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
labelStyle "'Data value, percent of total'"
legend
show "true"
position "'Right'"
showTitle "false"
fontSize "'9'"
Visualization "28e166680a992ae270ad"
Type "card"
Filters
Datasource Filter SELECT
"This Year Sales"
FROM
"s"."Sales"
Fields
Fields "This Year Sales"
Properties
categoryLabels
show "false"
labels
fontFamily "'''Segoe UI Bold'', wf_segoe-ui_bold, helvetica, arial, sans-serif'"
fontSize "'21'"
Visualization "820c6c0a465825cdbaa6"
Type "map"
Filters
Datasource Filter SELECT
"PostalCode"
,"Store Type"
,"This Year Sales"
FROM
"s"."Store"
,"s1"."Sales"
ORDER BY
"This Year Sales" DESC
Fields
Axis "PostalCode"
Legend "Store Type"
Size "This Year Sales"
Properties
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
mapStyles
mapTheme "'canvasLight'"
categoryLabels
show "false"
Visualization "ad292c567a76d115d6b0"
Type "multiRowCard"
Filters
Datasource Filter SELECT
"Last Year Sales"
FROM
"s1"."Sales"
ORDER BY
"Last Year Sales" DESC
Fields
Fields "Last Year Sales"
Properties
categoryLabels
show "true"
card
barWeight "6D"
Visualization "80525a2a6cb0c6829860"
Type "multiRowCard"
Filters
Datasource Filter SELECT
"New Stores"
FROM
"s"."Store"
ORDER BY
"New Stores" DESC
Fields
Fields "New Stores"
Properties
categoryLabels
show "true"
card
barWeight "6D"
Page Name "District Monthly Sales"
Visuals
Visualization "6c7a7c574d6b02dc3555"
Type "actionButton"
Properties
icon
shapeType "'qna'"
horizontalAlignment "'center'"
lineWeight "2L"
leftMargin "9L"
rightMargin "9L"
topMargin "9L"
bottomMargin "9L"
lineWeight "0L"
outline
show "false"
text
show "true"
text "'Q&A'"
horizontalAlignment "'center'"
fill
show "true"
transparency "0D"
Visualization "a79a49d01c0d120554ee"
Type "textbox"
Properties
general
paragraphs "STORE SALES"" REPORT"" ""District Monthly Sales"
Visualization "1deec7668b4e00593c8a"
Type "barChart"
Filters
Datasource Filter SELECT
"Name"
,"Chain"
,"TotalSales"
FROM
"s"."Store"
,"s1"."Sales"
ORDER BY
"TotalSales" DESC
Fields
Axis "Chain"
"Name"
Value "TotalSales"
Properties
labels
show "false"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
categoryAxis
axisType "'Categorical'"
maxMarginFactor "39L"
fontSize "9M"
preferredCategoryWidth "28D"
Visualization "2c29e3187a640040ca08"
Type "lineClusteredColumnComboChart"
Filters
Datasource Filter SELECT
"FiscalMonth"
,"Last Year Sales"
,"This Year Sales"
,"Total Sales Variance %"
FROM
"t"."Time"
,"s"."Sales"
ORDER BY
"FiscalMonth" ASC
Fields
Axis "FiscalMonth"
Value "Last Year Sales"
"This Year Sales"
Properties
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
categoryAxis
axisType "'Categorical'"
labels
show "false"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
lineStyles
showMarker "true"
Visualization "591aa65a098c04b86a92"
Type "scatterChart"
Filters
Datasource Filter SELECT
"Category"
,"Total Sales Variance %"
,"Avg $/Unit TY"
,"This Year Sales"
FROM
"i"."Item"
,"s"."Sales"
Fields
Axis "Category"
Value "Total Sales Variance %"
"Avg $/Unit TY"
Size "This Year Sales"
Properties
categoryLabels
show "true"
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
categoryAxis
axisType "'Categorical'"
xAxisReferenceLine
show "true"
displayName "'X-Axis Constant Line 1'"
Page Name "New Stores"
Visuals
Visualization "VisualContainer1"
Type "waterfallChart"
Filters
Datasource Filter SELECT
"FiscalMonth"
,"Total Sales Variance %"
FROM
"t"."Time"
,"s"."Sales"
,"s1"."Store"
WHERE
"Store Type" = "'New Store'"
Fields
Axis "FiscalMonth"
Value "Total Sales Variance %"
Properties
labels
show "true"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
labelPrecision "0L"
labelPosition "'Auto'"
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
Visualization "VisualContainer5"
Type "textbox"
Properties
general
paragraphs "obviEnce llc ©"
Visualization "59c7e7ba9474961b8b07"
Type "actionButton"
Properties
icon
shapeType "'qna'"
horizontalAlignment "'center'"
lineWeight "2L"
leftMargin "9L"
rightMargin "9L"
topMargin "9L"
bottomMargin "9L"
lineWeight "0L"
outline
show "false"
text
show "true"
text "'Q&A'"
horizontalAlignment "'center'"
fill
show "true"
transparency "0D"
Visualization "3e5a167570d3bc8d4991"
Type "textbox"
Properties
general
paragraphs "STORE SALES"" REPORT"" ""New Stores"
Visualization "80313843c4902b4d037e"
Type "lineStackedColumnComboChart"
Filters
Datasource Filter SELECT
"FiscalMonth"
,"Last Year Sales"
,"This Year Sales"
FROM
"t"."Time"
,"s"."Sales"
,"s1"."Store"
WHERE
"Store Type" = "'New Store'"
ORDER BY
"FiscalMonth" ASC
Fields
Axis "FiscalMonth"
Value "Last Year Sales"
Properties
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
categoryAxis
axisType "'Categorical'"
labels
show "false"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
lineStyles
strokeWidth "3D"
showMarker "true"
Visualization "7bcd06954e309e882c00"
Type "pivotTable"
Filters
Datasource Filter SELECT
"Chain"
,"Name"
,"Buyer"
,"This Year Sales"
,"Last Year Sales"
,"Total Sales Var %"
,"Total Sales Var"
FROM
"s1"."Sales"
,"s"."Store"
,"i"."Item"
WHERE
"Store Type" = "'New Store'"
ORDER BY
"This Year Sales" DESC
Fields
Fields "This Year Sales"
"Last Year Sales"
"Total Sales Var %"
"Total Sales Var"
Properties
grid
outlineWeight "3D"
gridVertical "true"
gridVerticalWeight "4D"
gridHorizontal "true"
gridHorizontalWeight "3D"
rowPadding "2D"
textSize "10D"
columnHeaders
fontFamily "'''Segoe UI Bold'', wf_segoe-ui_bold, helvetica, arial, sans-serif'"
fontSize "'11'"
wordWrap "false"
autoSizeColumnWidth "false"
outlineStyle "4L"
rowHeaders
stepped "true"
steppedLayoutIndentation "26D"
wordWrap "false"
showExpandCollapseButtons "true"
expandCollapseButtonsSize "'11'"
outlineStyle "2L"
values
bandedRowHeaders "true"
valuesOnRow "false"
outlineStyle "0L"
subTotals
levelSubtotalEnabled "true"
levelSubtotalEnabled "true"
applyToHeaders "true"
applyToHeaders "true"
columnWidth
value "161.06760709499864D"
value "355.8781237542206D"
value "173.04507139666575D"
value "87D"
value "354.25822934527844D"
value "231.08460404521313D"
value "223.10919079372232D"
value "110.6840242153855D"
value "228.4389095271605D"
value "217.0028991491381D"
value "207.10919079372232D"
value "229.5483870967742D"
value "223.09677419354836D"
value "170.41935483870967D"
value "169.7741935483871D"
value "400.1612903225806D"
value "401.8965489980887D"
value "143D"
value "135D"
columnFormatting
labelPrecision "0L"
rowTotal
fontSize "'15'"
applyToHeaders "true"
columnTotal
fontSize "'15'"
applyToHeaders "true"
Visualization "d54220008a7541967146"
Type "actionButton"
Properties
icon
shapeType "'blank'"
outline
show "false"
text
show "false"
fill
show "true"
transparency "0D"
Visualization "97ef12cb83896036aad7"
Type "gauge"
Filters
Datasource Filter SELECT
"Last Year Sales"
,"This Year Sales"
FROM
"s"."Sales"
,"s1"."Store"
WHERE
"Store Type" = "'New Store'"
Fields
Value "This Year Sales"
Properties
labels
show "true"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
fontSize "'9'"
target
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
fontSize "'10'"
show "true"
calloutValue
labelDisplayUnits "1D"
show "false"
Visualization "8a542ef24b03c88b5b68"
Type "image"
Properties
general
imageUrl "bar06114330545101687.png"
Visualization "3c7e6c9a40203dc0a802"
Type "image"
Properties
general
imageUrl "line-chart769759383509198.png"
Visualization "f3bb7f8cd258e0005680"
Type "actionButton"
Properties
icon
shapeType "'blank'"
outline
show "false"
text
show "false"
fill
show "true"
transparency "15D"
transparency "85D"
Visualization "3874ed98024140a01eb7"
Type "basicShape"
Properties
general
shapeType "'arrowbutton'"
fill
transparency "0D"
line
weight "0D"
rotation
angle "25D"
Visualization "84322b4f19780d09731e"
Type "basicShape"
Properties
general
shapeType "'line'"
rotation
angle "90D"
Visualization "e2a11e48e84b4d7d7c3a"
Type "card"
Filters
Datasource Filter SELECT
"TotalSalesTY"
FROM
"s"."Sales"
,"s1"."Store"
WHERE
"Store Type" = "'New Store'"
Fields
Fields "TotalSalesTY"
Properties
labels
labelPrecision "0L"
fontSize "'22'"
fontFamily "'''Segoe UI Bold'', wf_segoe-ui_bold, helvetica, arial, sans-serif'"
labelDisplayUnits "1000D"
categoryLabels
fontSize "'10'"
Visualization "1428008c11bb7eebaecc"
Type "basicShape"
Properties
general
shapeType "'line'"
rotation
angle "90D"
line
weight "13D"
Visualization "dd696799ddb70467dc26"
Type "basicShape"
Properties
general
shapeType "'line'"
rotation
angle "0D"
line
weight "13D"
Visualization "5b6375d715cf67182763"
Type "actionButton"
Properties
icon
shapeType "'blank'"
show "false"
outline
show "false"
fill
show "true"
transparency "100D"
transparency "50D"
Visualization "752f1277e552ec06ec72"
Type "actionButton"
Properties
icon
shapeType "'blank'"
show "false"
outline
show "false"
fill
show "true"
transparency "20D"
transparency "100D"
Visualization "b5df6a6e7e8ac9c44f29"
Type "actionButton"
Properties
icon
shapeType "'blank'"
show "false"
outline
show "false"
fill
show "true"
transparency "100D"
transparency "50D"
Visualization "d9b9605f9f651a223907"
Type "actionButton"
Properties
icon
shapeType "'blank'"
show "false"
outline
show "false"
fill
show "true"
transparency "20D"
transparency "100D"
Visualization "bbb8f5ac74be810acfe2"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
fill
show "false"
line
weight "0D"
Visualization "9358d0b17e4e2a78fda9"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
fill
show "false"
line
weight "0D"
Page Name "Page 4"
Visuals
Visualization "832f7ef35dde77d0fcb6"
Type "clusteredBarChart"
Filters
Datasource Filter SELECT
"TotalUnits"
,"Name"
FROM
"s"."Store"
,"s1"."Sales"
ORDER BY
"TotalUnits" DESC
Fields
Axis "Name"
Value "TotalUnits"
Properties
valueAxis
fontSize "7.5M"
categoryAxis
fontSize "7.5M"
Page Name "Info Page"
Visuals
Visualization "4a7216259985e2715647"
Type "textbox"
Properties
general
paragraphs "STORE SALES REPORT"" ""Detailed Info"
Visualization "7c5b71a787fb1f853e8b"
Type "actionButton"
Properties
icon
shapeType "'qna'"
horizontalAlignment "'center'"
lineWeight "2L"
leftMargin "9L"
rightMargin "9L"
topMargin "9L"
bottomMargin "9L"
lineWeight "0L"
outline
show "false"
text
show "true"
text "'Q&A'"
horizontalAlignment "'center'"
fill
show "true"
transparency "0D"
Visualization "7e0c57c5f4d4a296c70a"
Type "basicShape"
Properties
general
shapeType "'arrowbutton'"
fill
transparency "0D"
line
weight "0D"
rotation
angle "25D"
Visualization "f5e94eca32c5e52ad068"
Type "barChart"
Filters
Datasource Filter SELECT
"Category"
,"TotalSales"
FROM
"i"."Item"
,"s"."Sales"
ORDER BY
"TotalSales" DESC
Fields
Axis "Category"
Value "TotalSales"
Properties
labels
show "false"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
legend
show "true"
position "'Top'"
showTitle "false"
fontSize "'9'"
categoryAxis
axisType "'Categorical'"
fontSize "9M"
preferredCategoryWidth "28D"
maxMarginFactor "39L"