Sort Toggle

Back

Change chart sorting order with a click

Build

Overview

Features

Prompts

Help

Key Features

A ranked bar chart almost always sparks the opposite question — and what are the smallest ones? Giving users a sort switch means building two versions of the chart with opposite sort orders, a pair of buttons to flip between them, bookmarks to swap which one shows, and the fiddly wiring so the buttons don't upset your existing bookmarks, slicers, or interactions. This skill does all of it from one command: it duplicates the chart with the opposite sort, drops a chevron control in the top-right, and sets up display-only bookmarks that flip the view without touching anyone's slicer selections — and it never adds a measure or changes your model — run it with /sort-toggle.

How it works

Type /sort-toggle, point it at your chart (or charts), and it does the rest:

Looks at your chart — reads its current sort, checks the sort field is still valid, and picks up the report's theme accent colour
Confirms the default — which direction the chart shows on open (descending — largest first — is the recommended default)
Duplicates the chart — makes a second copy sorted the opposite way, keeping your original as the default so existing bookmarks and interactions keep working
Adds the chevron control — a small up/down control in the chart's top-right; the active direction is solid, the other dims and lights up in your theme accent on hover
Wires the bookmarks — two display-only bookmarks in their own named group that swap which copy is visible, without resetting any slicer the reader has set
Keeps everything tidy — groups all the pieces in the Selection pane, clones your interactions onto the duplicate, and patches any other bookmarks that show or hide the chart so they keep working
Follows bookmarks — the toggle works within the bookmarks the chart already lives in, and bookmark navigators still show only their own bookmarks

What you get

An up/down sort control — a compact chevron control in the chart's top-right, the active direction solid and the other lighting up in your theme accent on hover
A second chart copy — sorted the opposite way, hidden until the reader flips to it (your original stays the default)
Two display-only bookmarks — in their own named group, swapping the view without disturbing slicer selections
A Selection-pane group — holding the two charts and the buttons together so the page stays organised
No DAX, no model changes — the whole thing lives in the report; your measures and model are untouched

Explore more in this category