Funnel & Pyramid fields and settings
Every field well and every setting in the format pane of version 1.0.0.0, read from the package you download. The internal names in grey are what a PBIR file or a report-authoring agent uses. Which features need a licence is on the Funnel & Pyramid page; every setting works in edit mode with or without one.
12 fields · 23 cards · 113 settings Markdown for AI assistantscatalog.json
Fields
| Field | Takes | Needed | What it is for |
|---|---|---|---|
Categorycategory | Column | Optional | The parts: slices, petals, rings, cells, icons, stages or columns |
Segmentsegment | Column | Optional | A second split: an outer ring, stacked petals or stages, Marimekko rows, waffle colours |
Valuesvalues | Measure | Optional | The size of each part |
Comparecompare | Measure | Optional | Last period, plan or any reference: share shift, ghost marks, findings (premium) |
Targettarget | Measure | Optional | A goal per part |
Stage orderstageOrder | Measure | Optional | Sort key of the stages (1, 2, 3...) |
Win probabilityprobability | Measure | Optional | Chance each stage closes (0-1 or %): weighted pipeline (premium) |
Annotationannotation | Measure | Optional | Text measure: a callout on the part |
Small multiplesfacet | Column | Optional | One chart per value |
Tooltipstooltips | Measure | Optional | Extra fields in tooltips |
Loss reasonlossReason | Column | Optional | Why the lost left each step (blank = still open or won): splits the leak ribbons by reason (premium) |
Show conditionshowCondition | Measure | Optional | A measure returning 1 / TRUE to show the chart, 0 / FALSE / blank to show a message instead |
Templatestemplates
| Setting | Type and options |
|---|---|
Style Templatepreset |
|
Appliedapplied | Text |
Funnel & Pyramidfunnel
| Setting | Type and options |
|---|---|
Chartstyle |
|
Orientationorientation |
|
Shapeshape |
|
Level Heightsheights |
|
Connector Areasconnectors | On / off |
Minimum Stage Width (%)minWidth | Number |
Segment Field Assegments |
|
Conversion Pillspills | On / off |
Leak Ribbons (What Each Step Loses)leaks | On / off |
Leak Ribbon LabelsleakLabels | On / off |
Lane TitleslaneTitles | On / off |
% of First StageshowPctFirst | On / off |
% of Previous StageshowPctPrevious | On / off |
Drop %showDrop | On / off |
Lost (Absolute)showLoss | On / off |
Data Checks (edit mode)diagnostics | On / off |
Sorting and Othersorting
| Setting | Type and options |
|---|---|
Sortsort |
|
Readers Can Change the SortreaderSort | On / off |
Group Small Items Into Otherother | On / off |
Show at Most (items)maxItems | Number |
Group Items Below (%)minShare | Number |
Other LabelotherLabel | Text |
Data Labelslabels
| Setting | Type and options |
|---|---|
Showshow | On / off |
Contentcontent |
|
Positionposition |
|
Percent DecimalspercentDecimals | Number |
Display UnitsdisplayUnits |
|
Value Decimals (-1 = auto)valueDecimals | Number |
Hide Labels Below (%)hideBelow | Number |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Detail Text SizedetailSize | Number |
Detail Text ColourdetailColor | Colour |
Legendlegend
| Setting | Type and options |
|---|---|
Showshow | On / off |
Positionposition |
|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Colour RulescolorRules
| Setting | Type and options |
|---|---|
Rulemode |
|
Top NtopN | Number |
Thresholdthreshold | Number |
Highlight / Above ColourhighColor | Colour |
Others / Below ColourlowColor | Colour |
Comparecompare
| Setting | Type and options |
|---|---|
Show the Comparisonshow | On / off |
Comparison Namename | Text |
Change Labelslabels |
|
Draw the Comparison (ghost)ghost | On / off |
Sort by ChangesortByChange | On / off |
Volume vs Mix SplitvolumeMix | On / off |
Concentration (HHI, top 3)concentration | On / off |
Share Bridge (points won and lost)shareBridge | On / off |
Movers in the BridgebridgeItems | Number |
Segment CAGR Above Columnscagr | On / off |
Years Between the Periodsyears | Number |
Targetstargets
| Setting | Type and options |
|---|---|
Show Targetsshow | On / off |
One Target for All (0 = off)global | Number |
Met at (% of target)metAt | Number |
Close at (% of target)closeAt | Number |
Met ColourmetColor | Colour |
Close ColourcloseColor | Colour |
Missed ColourmissedColor | Colour |
Colour Items by StatusstatusColors | On / off |
Significancesignificance
| Setting | Type and options |
|---|---|
Test the Changeshow | On / off |
Significance Levelalpha |
|
Values ArevaluesAre |
|
Test Againstreference |
|
Pipeline & Forecastpipeline
| Setting | Type and options |
|---|---|
Show Expected Valueshow | On / off |
Stages ArestagesAre |
|
Last Stage Is Won (counted at 100 %)lastIsWon | On / off |
Pipeline Coveragecoverage |
|
Quota (0 = the last stage's Target)quota | Number |
Forecast Line Under the CharttotalLine | On / off |
What IfwhatIf
| Setting | Type and options |
|---|---|
Lift One Stepshow | On / off |
Step Into Stage (blank = the weakest step)step | Text |
Uplift (percentage points)uplift | Number |
Uplift LabelsshowText | On / off |
Findingsfindings
| Setting | Type and options |
|---|---|
What Changed (findings)show | On / off |
Number of Findingsmax | Number |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Smart Captioncaption
| Setting | Type and options |
|---|---|
Showshow | On / off |
Positionposition |
|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Small MultiplessmallMultiples
| Setting | Type and options |
|---|---|
Columns (0 = auto)columns | Number |
Shared ScalesharedScale | On / off |
Size Pies by Their TotalsizeByTotal | On / off |
Title Font SizetitleSize | Number |
Title ColourtitleColor | Colour |
Annotationsannotations
| Setting | Type and options |
|---|---|
Showshow | On / off |
Font SizefontSize | Number |
Colourcolor | Colour |
Show ConditionshowCondition
| Setting | Type and options |
|---|---|
Message When Hiddenmessage | Text |
Data TabledataTable
| Setting | Type and options |
|---|---|
Table Button in the Visualbutton | On / off |
Open as Tablestart | On / off |
Zoomzoom
| Setting | Type and options |
|---|---|
Ctrl + Wheel Zooms, Drag Pansenabled | On / off |
Footnotefootnote
| Setting | Type and options |
|---|---|
Showshow | On / off |
Sourcesource | Text |
State the MethodsshowMethod | On / off |
Font SizefontSize | Number |
Text Colourcolor | Colour |
Tabs and Buttonscontrols
| Setting | Type and options |
|---|---|
Font SizefontSize | Number |
Text Colourcolor | Colour |
Accessibilityaccessibility
| Setting | Type and options |
|---|---|
Patterns (Tell Items Apart Without Colour)patterns | On / off |
Focus Outline ColourfocusColor | Colour |
Focus Outline WidthfocusWidth | Number |
Minimum Text Size (0 = off)minFontSize | Number |
Reduce MotionreduceMotion | On / off |
Themetheme
| Setting | Type and options |
|---|---|
ThemeselectedTheme |
|
Fontfont |
|
Transparent BackgroundtransparentBg | On / off |
Data ColoursdataPoint
| Setting | Type and options |
|---|---|
Colourfill | Colour |
Setting a value in PBIR
In a visual.json, a setting goes under visual.objects, by card and internal name. Toggles take true or false, choices and text a value in single quotes ('auto'), numbers a D suffix (12D).
"visual": {
"visualType": "smartvisualsFunnelPyramidBF281E689F48B9242B4CA92FDB7DDAB6",
"objects": {
"funnel": [{
"properties": {
"connectors": { "expr": { "Literal": { "Value": "true" } } }
}
}]
}
}