Range Slicer 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 Range Slicer page; every setting works in edit mode with or without one.

    7 fields · 13 cards · 88 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    Numeric fieldvalueColumnOptionalThe numeric column to filter: price, age, lead time, discount… The slider ranges over its values and the histogram shows how they are distributed.
    Entity (measure per entity)entityColumnOptionalInstead of a numeric field: an entity column (Customer, Product) plus a Measure. The slider then ranges over the measure per entity, and the filter keeps the entities in range.
    MeasuremeasureMeasureOptionalWith a numeric field: how many rows each value stands for (e.g. Count of Orders), so the histogram counts rows. With an entity: the value per entity that the slider ranges over.
    Second numeric field (premium)field2ColumnOptionalA second numeric column with its own slider; both ranges filter together (AND). Disables sync slicers.
    Split by (premium)segmentColumnOptionalA category that splits the histogram into coloured parts (region, channel, segment).
    Comparison (premium)compareMeasureOptionalA measure drawn as an outline over the histogram, e.g. the same count for the previous year.
    TooltipstooltipsMeasureOptional · up to 5Extra measures shown when hovering a bar. The first one also feeds the readout (the measure kept and its share).

    Bar coloursdataPoint

    SettingType and options
    Bars in rangefillColour
    Bars out of rangeoutFillColour

    Bar coloursentityPoint

    SettingType and options
    Bars in rangefillColour
    Bars out of rangeoutFillColour

    Sliderslider

    SettingType and options
    Selectionmode
    • Between range
    • At least atLeast
    • At most atMost
    • Single value single
    Orientationorientation
    • Horizontal horizontal
    • Vertical vertical
    StepstepText
    Handles snapsnap
    • To the step step
    • To values in the data data
    • To bin edges bins
    • Free none
    Boundsbounds
    • Follow other filters follow
    • Fixed (widest seen) fixed
    Open at the endsopenEndsOn / off
    Typed inputsshowInputsOn / off
    Handle valuesshowLabelsOn / off
    Handle value sizelabelFontSizeNumber
    Apply buttonapplyButtonOn / off

    Histogramhistogram

    SettingType and options
    Show histogramshowOn / off
    Stylestyle
    • Bars bars
    • Curve curve
    • Dots dots
    Binsbins
    • Rounded (recommended) nice
    • Automatic (numpy auto) auto
    • Freedman–Diaconis fd
    • Sturges sturges
    • Square root sqrt
    • Fixed count fixed
    Bin count (fixed)binCountNumber
    Bar height scaleyScale
    • Linear linear
    • Square root sqrt
    • Logarithmic log
    Value scalexScale
    • Auto (logarithmic for long tails) auto
    • Linear linear
    • Logarithmic (positive values) log
    Median markershowMedianOn / off
    Mean markershowMeanOn / off
    Axis labelsshowAxisOn / off
    Axis text sizeaxisFontSizeNumber
    Marker text sizemarkerFontSizeNumber
    Draw a range on the histogramdrawToSelectOn / off
    Gap between bars (px)barGapNumber

    Presetspresets

    SettingType and options
    Show presetsshowOn / off
    Chip text sizefontSizeNumber
    QuartilesquartilesOn / off
    Middle 50% and median splitmiddleOn / off
    Top and bottom 10%tailsOn / off
    Without outliers (Tukey)outliersOn / off
    Above the meanmeanOn / off
    Equal groupsgroupsNumber
    Default selectiondefaultRule
    • None (everything) none
    • Custom range (below) custom
    • 1st quartile q1
    • 2nd quartile q2
    • 3rd quartile q3
    • 4th quartile q4
    • Middle 50% iqr
    • Above the median aboveMedian
    • Below the median belowMedian
    • Top 10% top10
    • Bottom 10% bottom10
    • Mean ± 1σ (premium) sigma1
    • Mean ± 2σ (premium) sigma2
    • P5 – P95 (premium) p5p95
    • P1 – P99 (premium) p1p99
    • Without outliers noOutliers
    • Above the mean aboveMean
    • Above the target (premium) aboveTarget
    • Top N% (premium) topN
    • Bottom N% (premium) bottomN
    Default fromdefaultFromText
    Default todefaultToText

    Readoutreadout

    SettingType and options
    Show what the range keepsshowOn / off
    Text sizefontSizeNumber
    Positionposition
    • In the header header
    • Below the slider below
    Share of the totalshowShareOn / off
    Measure totalshowMeasureOn / off
    Median of the kept valuesshowMedianOn / off

    Distribution rules (premium)rules

    SettingType and options
    Keep rules liveliveOn / off
    Mean ± 1σ / 2σsigmaOn / off
    P5 – P95 and P1 – P99percentilesOn / off
    Top / bottom N%topPercentNumber
    Several ranges (Shift + drag)multiRangeOn / off
    Exclude modeexcludeOn / off
    TargettargetText
    Named bucketsbucketsText

    Distribution analysis (premium)analysis

    SettingType and options
    Split the distributionsplit
    • Off none
    • By the Segment field segment
    • Against the Comparison measure compare
    • Against the data as first loaded total
    Joint density of the two fieldsdensityOn / off
    Top entities listedtopNNumber
    What the range droppedshowDroppedOn / off
    Kept / dropped text sizelistFontSizeNumber

    Legendlegend

    SettingType and options
    Show legendshowOn / off
    Positionposition
    • Below the histogram bottom
    • Above the histogram top
    Text sizefontSizeNumber
    Text colourfontColorColour

    Headerheader

    SettingType and options
    Show headershowOn / off
    TitletitleText
    Title sizefontSizeNumber
    Title colourfontColorColour
    Reset buttonshowResetOn / off

    Numbersnumbers

    SettingType and options
    Display unitsunits
    • Auto auto
    • None none
    • Thousands (K) K
    • Millions (M) M
    • Billions (B) B
    Decimalsdecimals
    • Auto auto
    • 0
    • 1
    • 2
    • 3
    • 4
    PrefixprefixText
    SuffixsuffixText

    Theme and coloursstyle

    SettingType and options
    Style templatetemplate
    • None (defaults) custom
    • Custom (modified template) modified
    • Executive executive
    • Analyst analyst
    • Minimal minimal
    • Presentation presentation
    • Print print
    • Compact compact
    Themetheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean clean
    • Slate slate
    FontfontFamily
    • Theme default theme
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    Text sizefontSizeNumber
    Text colourfontColorColour
    Selection colouraccentColorColour
    Bars in rangebarColorColour
    Bars out of rangebarOutColorColour
    Comparison colourcompareColorColour
    BackgroundbackgroundColour
    BordershowBorderOn / off
    Border colourborderColorColour
    Corner radiusradiusNumber

    Accessibilityaccessibility

    SettingType and options
    Focus ring colourfocusColorColour
    Focus ring widthfocusWidthNumber
    Minimum text sizeminFontSizeNumber
    Hatch bars out of rangepatternsOn / off
    Reduce motionreduceMotionOn / off

    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": "rangeSlicer8A9668ED26794BDBAA65CA06A7C8B418",
      "objects": {
        "slider": [{
          "properties": {
            "openEnds": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }