Measure Slicer

Back

Let your users choose which measures to see

Build

Overview

Features

Prompts

Help

Key Features

A chart that plots Sales, Cost, and Profit together can get crowded, and different readers want different things from it. The tidy answer is to let them choose: a little button per measure, where picking one or two narrows the chart down and picking none brings everything back. Building that by hand is fiddly, though — you need a small table to drive the buttons, a switchable version of every measure on the chart, a title that names whatever's currently shown, a button slicer styled to match the page, and interaction rules so the buttons don't disturb the rest of the page.

This skill builds the whole thing in one go, and selecting nothing always falls back to showing every measure — run it with /measure-slicer.

How it works

Type /measure-slicer, point it at your chart, and it does the rest:

Looks at your chart — finds the measures on the Y-axis, the measure table, and how the page's slicers are styled
Suggests short labels — a two-letter abbreviation per measure (TS for TotalSales, TC for TotalCost), which you can accept or rename
Confirms one thing — which folder the new measures should live in (default: _MeasureSlicer)
Builds switchable measures — a version of each measure that appears only when its button is selected, or always when none are
Adds a self-updating title — names the measures currently shown, and reads as all of them when nothing is selected
Points the chart at it — swaps the chart over to the switchable measures while the legend keeps the original names
Drops in the buttons — a compact multi-select slicer in the chart's top-right corner, styled to match your page
Keeps it tidy — the buttons only affect this one chart, and nothing else on the page can change them
Follows bookmarks — if the chart shows and hides with a bookmark, the buttons are grouped with it so they come and go together

What you get

A row of measure buttons — a compact multi-select slicer in the chart's top-right corner, matching your page style
Pick-what-you-want behaviour — select one or two buttons to narrow the chart; select nothing to show every measure
A self-updating title — names the measures on display and reads as the full set when nothing is selected
Switchable measures — one per measure on the chart, so the right lines or bars appear for whatever's selected
Original names in the legend — the chart still labels measures by their real names, not the behind-the-scenes versions
Clean interactions — the buttons drive only this chart and stay out of everyone else's way
Bookmark grouping — set up for you when the chart is shown and hidden by a bookmark

Explore more in this category

Absolute / Percentage Toggle

Build

Add a two-button tile slicer to any chart that switches between absolute values and a percentage variant, with a dynamic format string and auto-derived chart title.

Active Filters Card Visual

Build

Generate a card visual that dynamically displays all currently active slicer and filter selections.

Apply rounded

Build

Convert standard column or bar charts to a lollipop "rounded column" style using Power BI's native error bar feature

Clone Page

Build

Clone any report page with all visuals and bookmarks

Tool Information

Skill

39 USD

Bundle (All skills)

129 USD