Absolute / Percentage Toggle

Back

Absolute / Percentage Toggle

# / % Switch for Chart Visuals

Build

Overview

Features

Prompts

Help

Key Features

Your bar chart shows total sales, but stakeholders also want to see each segment as a percentage. Maintaining two separate visuals doubles the report surface. Building the toggle manually means creating a disconnected parameter table, a switch measure with a dynamic format string, a tile slicer, a dynamic title measure, and interaction restrictions — and getting the compatibility level or TMDL indentation wrong silently breaks the format string at runtime. This skill builds all of it in one command — run it with /abs-pct-toggle.

How it works

Type /abs-pct-toggle, provide the chart ID, base measure, and percentage variant, and the skill handles everything:

Verifies model compatibility and upgrades automatically if required
Builds the switching infrastructure — a shared parameter table reused across all toggles in the model
Adds a switch measure with a dynamic format string and a dynamic title measure to your semantic model
Updates the target chart to use the switch measure and wires the dynamic title
Creates a tile slicer above the chart, sized and styled to match existing page slicers
Sets interaction rules so the slicer only filters the target chart

What you get

Disconnected parameter table — two-row table shared across all toggles on the model
Switch measure — routes to the base measure or percentage variant based on selection, with a format string that changes on toggle
Title measure — returns the absolute or percentage title string depending on the selection
Updated chart visual — value axis references the switch measure; title bound to the title measure
Tile slicer — positioned directly above the chart, right-aligned, styled to match the page
Scoped interactions — the slicer filters only the target chart

Explore more in this category