| Location: | Local or Network Folders |
| Host: | FINDITEZ-X1GEN2 |
| Path: | C:\Users\kgnazdowsky\Documents\Find IT EZ Docs\Test Cases\PowerBI\Revenue Opportunities.pbix |
Report Layout
Page Name "Opportunity Overview"
Visuals
Visualization "0fa4715079a4d5b14dc6"
Type "card"
Filters
Datasource Filter SELECT
"Total Revenue"
FROM
"f"."Sales"
Fields
Fields "Total Revenue"
Visualization "2a48b7b9c411369725ca"
Type "card"
Filters
"Categorical" Filter "Sales Stage" not in ("'Finalize'")
Datasource Filter SELECT
"Total Opportunity Count"
FROM
"f"."Sales"
,"s"."SalesStages"
WHERE
"Sales Stage" not in ("'Finalize'")
Fields
Fields "Total Opportunity Count"
Visualization "77960fe4d6dd7e864e6c"
Type "slicer"
Filters
Datasource Filter SELECT
"Product Code"
FROM
"p"."Products"
Fields
Fields "Product Code"
Properties
data
mode "'Dropdown'"
general
selfFilterEnabled "true"
header
show "true"
Visualization "eaf58d9fd08140688010"
Type "treemap"
Filters
"Advanced" Filter "Total Opportunity Count"
"Categorical" Filter "Region"
"Categorical" Filter "Sales Stage"
"Categorical" Filter "State"
Datasource Filter SELECT
"Region"
,"Total Opportunity Count"
,"State"
FROM
"a"."Accounts"
,"f"."Sales"
ORDER BY
"Total Opportunity Count" DESC
Fields
Fields "Total Opportunity Count"
Properties
categoryLabels
fontSize "8D"
Visualization "91b894da4c7a504a0d7c"
Type "filledMap"
Filters
Datasource Filter SELECT
"State"
,"Total Revenue"
FROM
"a"."Accounts"
,"f"."Sales"
Fields
Axis "State"
Properties
mapStyles
mapTheme "'grayscale'"
showLabels "true"
categoryLabels
show "false"
Visualization "efc42a2f1a28997b4092"
Type "lineStackedColumnComboChart"
Filters
Datasource Filter SELECT
"Total Revenue"
,"Total Opportunity Count"
,"Month"
FROM
"f"."Sales"
,"d"."Dates"
ORDER BY
"Month" ASC
Fields
Axis "Month"
Value "Total Revenue"
Properties
valueAxis
secShow "true"
secShowAxisTitle "false"
secFontSize "8D"
titleFontSize "8D"
Visualization "772b1906500006b78011"
Type "barChart"
Filters
Datasource Filter SELECT
"Sales Stage"
,"Total Opportunity Count"
FROM
"s"."SalesStages"
,"f"."Sales"
ORDER BY
"Total Opportunity Count" DESC
Fields
Axis "Sales Stage"
Value "Total Opportunity Count"
Properties
legend
showGradientLegend "false"
show "false"
showTitle "false"
categoryAxis
fontSize "8D"
titleFontSize "10D"
concatenateLabels "true"
valueAxis
fontSize "8D"
titleFontSize "10D"
Visualization "5eab58ef36b6d8e189b8"
Type "textbox"
Properties
general
paragraphs "Revenue Opportunities Report"
"Opportunity overview"
Visualization "8a2c970418c8c8b490ba"
Type "barChart"
Filters
Datasource Filter SELECT
"Region"
,"Total Revenue"
,"State"
FROM
"f"."Sales"
,"a"."Accounts"
ORDER BY
"Total Revenue" DESC
Fields
Axis "Region"
"State"
Value "Total Revenue"
Properties
legend
showGradientLegend "true"
show "true"
showTitle "false"
categoryAxis
concatenateLabels "true"
Visualization "6a5e17d07518a05c0199"
Type "actionButton"
Properties
icon
shapeType "'rightArrow'"
horizontalAlignment "'right'"
leftMargin "7L"
rightMargin "7L"
topMargin "7L"
bottomMargin "7L"
fill
show "true"
transparency "100D"
text
show "true"
text "'Select a State below to enable Drill through'"
horizontalAlignment "'left'"
leftMargin "0L"
text "'Drill through to Detail'"
horizontalAlignment "'right'"
rightMargin "47L"
Visualization "3dbf0350b6557bb0123c"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
line
weight "0D"
Visualization "486075c0dea4b17203b4"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
line
weight "0D"
Visualization "1cd701506eae32ccc9c1"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
line
weight "0D"
Visualization "e786ef5a3d5c190c008d"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
line
weight "0D"
Visualization "f74cdd95c20076a4b388"
Type "basicShape"
Properties
general
shapeType "'rectangle'"
line
weight "0D"
Visualization "2a3a4013ecf8bfed538a"
Type "shape"
Properties
shape
tileShape "'rectangle'"
rotation
shapeAngle "0L"
outline
show "false"
Page Name "Detail"
Visuals
Visualization "df4f5199190e7a2291de"
Type "pivotTable"
Filters
Datasource Filter SELECT
"Opportunity Size"
,"Region"
,"Partner"
,"Total Opportunity Count"
,"Total Revenue"
,"Average Revenue"
,"Average Opportunity Days"
FROM
"o"."Opportunities"
,"a"."Accounts"
,"p"."Partners"
,"f"."Sales"
ORDER BY
"Total Revenue" DESC
Fields
Fields "Total Opportunity Count"
"Average Opportunity Days"
"Average Revenue"
"Total Revenue"
Properties
columnWidth
value "161.06760709499864D"
value "355.8781237542206D"
value "173.04507139666575D"
value "87D"
value "354.25822934527844D"
value "137.24011957356421D"
value "118.95501770155786D"
value "227.3223873331301D"
value "147.30479145518174D"
value "165D"
value "136.2293692899064D"
value "198D"
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
steppedLayoutIndentation "26D"
wordWrap "true"
showExpandCollapseButtons "true"
expandCollapseButtonsSize "'11'"
outlineStyle "2L"
values
bandedRowHeaders "true"
valuesOnRow "false"
outlineStyle "0L"
subTotals
perRowLevel "false"
levelSubtotalEnabled "true"
levelSubtotalEnabled "true"
applyToHeaders "true"
applyToHeaders "true"
rowTotal
fontSize "'15'"
applyToHeaders "true"
columnTotal
fontSize "'15'"
applyToHeaders "true"
general
layout "'Tabular'"
Visualization "2b022e3ea05009a0e305"
Type "actionButton"
Properties
icon
shapeType "'back'"
horizontalAlignment "'center'"
leftMargin "6L"
rightMargin "6L"
topMargin "6L"
bottomMargin "6L"
show "true"
Visualization "d922170a10104e3e8606"
Type "textbox"
Properties
general
paragraphs "Opportunity Analysis Report"
"Opportunity detail"
Page Name "Tooltip"
Visuals
Visualization "f2743f4e08200c0ed75b"
Type "donutChart"
Fields
Axis "Account.Segment"
Value "Fact.Revenue"
Properties
legend
show "false"
position "'Right'"
showTitle "false"
fontSize "'9'"
labels
show "true"
fontFamily "'''Segoe UI'', wf_segoe-ui_normal, helvetica, arial, sans-serif'"
labelStyle "'Both'"
Visualization "4d97de1a92eb689d8025"
Type "card"
Fields
Fields "Fact.Revenue"
Properties
labels
fontSize "16D"
labelPrecision "1L"
preserveWhitespace "true"
wordWrap
show "true"
categoryLabels
show "false"