****************************************************************************
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"