Absolute / Percentage Toggle
# / % Switch for Chart Visuals
Build
Overview
Features
Prompts
Troubleshooting
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 and drifts out of sync. Building the toggle manually means creating a disconnected parameter table, a switch measure with `formatStringDefinition`, a tile slicer, a dynamic title measure, and interaction restrictions — and getting the TMDL indentation rules wrong silently breaks the format string at runtime. This skill builds all of it in one command.
How it works
Type `/abs-pct-toggle`, provide the chart ID, base measure, and percentage variant, and the skill handles everything:
Checks `database.tmdl` compatibility level and upgrades to 1601 if needed
Creates a disconnected `prmAggregation` table with `#` and `%` rows (reuses if already present)
Adds a switch measure with `formatStringDefinition` to the measure table
Adds a dynamic title measure — absolute and percentage titles derived from the chart's fields
Updates the target chart's Y-axis 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
prmAggregationtable — disconnected two-row table shared across all toggles on the modelSwitch measure —
IF(SELECTEDVALUE(Order, 1) = 2, [PctExpr], [BaseMeasure])withformatStringDefinitionthat changes the number format on toggleTitle measure — returns the absolute or percentage title string depending on the selection
Updated chart visual — Y-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
Active Filters Card Visual
Build
Generate a card visual that dynamically displays all currently active slicer and filter selections.
Clone Page
Build
Clone any report page with all visuals, bookmark navigators, interactions, and drillthrough bindings as a fully independent copy.
Convert to Trendline
Build
Add formatted data labels, markers, area shading, and a canvas tooltip to line chart visuals.
Create Tooltip
Build