# SmartVisuals Range Slicer for Power BI

> Numeric range slicer for Power BI with the histogram behind the slider, quartile and top 10% presets, filter customers by a measure, and what the range keeps.

- Page: https://www.smartvisuals.io/visuals/range-slicer
- Fields and settings: https://www.smartvisuals.io/visuals/range-slicer/settings
- Microsoft Marketplace: https://marketplace.microsoft.com/en-us/product/smartvisuals.smartvisuals-range-slicer?tab=overview
- Package: https://www.smartvisuals.io/downloads/smartvisuals-range-slicer-1.0.0.0.pbiviz
- Price: Free tier for every viewer; premium $1.99 per user per month or $19 per user per year on Microsoft Marketplace, with a 30-day free trial. Premium works in edit mode without a licence; unlicensed viewers see the free tier, never a blocked visual.
- Certified by Microsoft: no
- Version: 1.0.0.0
- GUID (visualType and publicCustomVisuals): `rangeSlicer8A9668ED26794BDBAA65CA06A7C8B418`

## What is free

- **Histogram behind the slider**: Bars, a curve or dots; rounded, automatic, Freedman–Diaconis, Sturges, square-root or fixed bins; a log scale that switches on for long tails; median and mean markers.
- **Presets in one click**: Quartiles, middle 50%, above or below the median or mean, top or bottom 10%, without outliers and N equal groups, computed like numpy.
- **What the range keeps**: The share kept, rows kept of the total in their real name, the measure kept and its share, and the median of the kept values.
- **Measure per entity**: Filter customers or products by a measure, such as revenue 50k to 300k, with no DAX; re-listed when other filters change.
- **Every way to choose**: Drag the handles or the window, draw on the bars, click a bar, or type "10-50" or ">200" with your locale's separators, 1.5k, 2M, % and currency.
- **Between, at least, at most or one value**: Horizontal or vertical, a step setting, snapping to the step, to data values or to bin edges, and open ends after a refresh.
- **Default selection and Apply**: Open on any preset or a custom range, a Reset button, and an Apply button for heavy models.
- **Plays well with the report**: Bookmarks, sync slicers, cross-highlight on the bars, tooltips with up to five measures, report page tooltips, dynamic format strings.
- **On-object formatting and fx**: Style the header, histogram, slider, presets, readout and inputs on the canvas; conditional formatting on the bar colours by any measure.
- **Templates and setup guide**: Executive, Analyst, Minimal, Presentation, Print and Compact; an empty slicer says which field goes where.
- **Any size, four themes**: A full histogram, a compact slider with presets in a menu, or one line on small tiles; SmartVisuals, Dark, Clean and Slate.
- **Accessibility and 20 languages**: Keyboard sliders, screen-reader labels and a histogram data table, high contrast, hatched out-of-range bars, reduced motion, in 20 languages.

## What premium adds

- **Live rules**: Top 10%, mean ± 1σ or 2σ, P5 – P95, P1 – P99, top or bottom N% and above a target, re-resolved after a refresh or a cross-filter.
- **Several ranges and exclude bands**: Shift + drag or type "10-50; >200" for several bands at once, or exclude them instead.
- **Named buckets**: "Budget: <40; Standard: 40-120; Premium: 120+" as chips your readers click, one or several.
- **A second field**: A second numeric field with its own slider and a joint density: drag a rectangle to set both ranges.
- **Distribution split and comparison**: The histogram stacked by a segment, against a comparison measure such as last year, or against the data as first loaded.
- **Who was kept and dropped**: The top entities the range kept and dropped, with Other, as a report page tooltip; measure per entity beyond 30,000 entities.

## Fields

| Field | Internal name | Takes | Needed | What it is for |
| --- | --- | --- | --- | --- |
| Numeric field | `value` | Column | Optional | The 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) | `entity` | Column | Optional | Instead 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. |
| Measure | `measure` | Measure | Optional | With 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) | `field2` | Column | Optional | A second numeric column with its own slider; both ranges filter together (AND). Disables sync slicers. |
| Split by (premium) | `segment` | Column | Optional | A category that splits the histogram into coloured parts (region, channel, segment). |
| Comparison (premium) | `compare` | Measure | Optional | A measure drawn as an outline over the histogram, e.g. the same count for the previous year. |
| Tooltips | `tooltips` | Measure | Optional, up to 5 | Extra measures shown when hovering a bar. The first one also feeds the readout (the measure kept and its share). |

## Format pane

Each card is a key under `visual.objects` in a PBIR visual.json; each setting is a property of it. Toggles take `true`/`false`, choices and text a value in single quotes (`'auto'`), numbers a `D` suffix (`12D`).

### Bar colours (`dataPoint`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Bars in range | `fill` | Colour |
| Bars out of range | `outFill` | Colour |

### Bar colours (`entityPoint`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Bars in range | `fill` | Colour |
| Bars out of range | `outFill` | Colour |

### Slider (`slider`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Selection | `mode` | `range` (Between), `atLeast` (At least), `atMost` (At most), `single` (Single value) |
| Orientation | `orientation` | `horizontal` (Horizontal), `vertical` (Vertical) |
| Step | `step` | Text |
| Handles snap | `snap` | `step` (To the step), `data` (To values in the data), `bins` (To bin edges), `none` (Free) |
| Bounds | `bounds` | `follow` (Follow other filters), `fixed` (Fixed (widest seen)) |
| Open at the ends | `openEnds` | On / off |
| Typed inputs | `showInputs` | On / off |
| Handle values | `showLabels` | On / off |
| Handle value size | `labelFontSize` | Number |
| Apply button | `applyButton` | On / off |

### Histogram (`histogram`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show histogram | `show` | On / off |
| Style | `style` | `bars` (Bars), `curve` (Curve), `dots` (Dots) |
| Bins | `bins` | `nice` (Rounded (recommended)), `auto` (Automatic (numpy auto)), `fd` (Freedman–Diaconis), `sturges` (Sturges), `sqrt` (Square root), `fixed` (Fixed count) |
| Bin count (fixed) | `binCount` | Number |
| Bar height scale | `yScale` | `linear` (Linear), `sqrt` (Square root), `log` (Logarithmic) |
| Value scale | `xScale` | `auto` (Auto (logarithmic for long tails)), `linear` (Linear), `log` (Logarithmic (positive values)) |
| Median marker | `showMedian` | On / off |
| Mean marker | `showMean` | On / off |
| Axis labels | `showAxis` | On / off |
| Axis text size | `axisFontSize` | Number |
| Marker text size | `markerFontSize` | Number |
| Draw a range on the histogram | `drawToSelect` | On / off |
| Gap between bars (px) | `barGap` | Number |

### Presets (`presets`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show presets | `show` | On / off |
| Chip text size | `fontSize` | Number |
| Quartiles | `quartiles` | On / off |
| Middle 50% and median split | `middle` | On / off |
| Top and bottom 10% | `tails` | On / off |
| Without outliers (Tukey) | `outliers` | On / off |
| Above the mean | `mean` | On / off |
| Equal groups | `groups` | Number |
| Default selection | `defaultRule` | `none` (None (everything)), `custom` (Custom range (below)), `q1` (1st quartile), `q2` (2nd quartile), `q3` (3rd quartile), `q4` (4th quartile), `iqr` (Middle 50%), `aboveMedian` (Above the median), `belowMedian` (Below the median), `top10` (Top 10%), `bottom10` (Bottom 10%), `sigma1` (Mean ± 1σ (premium)), `sigma2` (Mean ± 2σ (premium)), `p5p95` (P5 – P95 (premium)), `p1p99` (P1 – P99 (premium)), `noOutliers` (Without outliers), `aboveMean` (Above the mean), `aboveTarget` (Above the target (premium)), `topN` (Top N% (premium)), `bottomN` (Bottom N% (premium)) |
| Default from | `defaultFrom` | Text |
| Default to | `defaultTo` | Text |

### Readout (`readout`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show what the range keeps | `show` | On / off |
| Text size | `fontSize` | Number |
| Position | `position` | `header` (In the header), `below` (Below the slider) |
| Share of the total | `showShare` | On / off |
| Measure total | `showMeasure` | On / off |
| Median of the kept values | `showMedian` | On / off |

### Distribution rules (premium) (`rules`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Keep rules live | `live` | On / off |
| Mean ± 1σ / 2σ | `sigma` | On / off |
| P5 – P95 and P1 – P99 | `percentiles` | On / off |
| Top / bottom N% | `topPercent` | Number |
| Several ranges (Shift + drag) | `multiRange` | On / off |
| Exclude mode | `exclude` | On / off |
| Target | `target` | Text |
| Named buckets | `buckets` | Text |

### Distribution analysis (premium) (`analysis`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Split the distribution | `split` | `none` (Off), `segment` (By the Segment field), `compare` (Against the Comparison measure), `total` (Against the data as first loaded) |
| Joint density of the two fields | `density` | On / off |
| Top entities listed | `topN` | Number |
| What the range dropped | `showDropped` | On / off |
| Kept / dropped text size | `listFontSize` | Number |

### Legend (`legend`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show legend | `show` | On / off |
| Position | `position` | `bottom` (Below the histogram), `top` (Above the histogram) |
| Text size | `fontSize` | Number |
| Text colour | `fontColor` | Colour |

### Header (`header`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Show header | `show` | On / off |
| Title | `title` | Text |
| Title size | `fontSize` | Number |
| Title colour | `fontColor` | Colour |
| Reset button | `showReset` | On / off |

### Numbers (`numbers`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Display units | `units` | `auto` (Auto), `none` (None), `K` (Thousands (K)), `M` (Millions (M)), `B` (Billions (B)) |
| Decimals | `decimals` | `auto` (Auto), `0`, `1`, `2`, `3`, `4` |
| Prefix | `prefix` | Text |
| Suffix | `suffix` | Text |

### Theme and colours (`style`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Style template | `template` | `custom` (None (defaults)), `modified` (Custom (modified template)), `executive` (Executive), `analyst` (Analyst), `minimal` (Minimal), `presentation` (Presentation), `print` (Print), `compact` (Compact) |
| Theme | `theme` | `smartvisuals` (SmartVisuals), `dark` (Dark), `clean` (Clean), `slate` (Slate) |
| Font | `fontFamily` | `theme` (Theme default), `inter` (Inter), `segoe` (Segoe UI), `arial` (Arial), `georgia` (Georgia) |
| Text size | `fontSize` | Number |
| Text colour | `fontColor` | Colour |
| Selection colour | `accentColor` | Colour |
| Bars in range | `barColor` | Colour |
| Bars out of range | `barOutColor` | Colour |
| Comparison colour | `compareColor` | Colour |
| Background | `background` | Colour |
| Border | `showBorder` | On / off |
| Border colour | `borderColor` | Colour |
| Corner radius | `radius` | Number |

### Accessibility (`accessibility`)

| Setting | Internal name | Type or options |
| --- | --- | --- |
| Focus ring colour | `focusColor` | Colour |
| Focus ring width | `focusWidth` | Number |
| Minimum text size | `minFontSize` | Number |
| Hatch bars out of range | `patterns` | On / off |
| Reduce motion | `reduceMotion` | On / off |
