Month Abbreviation Axis
Single-Letter Month Labels (JFMAMJJASOND)
Build
Overview
Features
Prompts
Troubleshooting
Key Features
Power BI charts with monthly data default to long month names ("January") or three-letter abbreviations ("Jan") — both consume axis space. Single letters are more compact, but J appears in January, June, and July. Power BI treats them as the same value, collapses duplicates in slicers, and sorts them alphabetically. The zero-width space (ZWS) trick makes each letter visually identical but internally unique by appending N invisible characters to the Nth month. This skill creates the column, sets the sort-by relationship to the numeric month column, and optionally rewires the chart axis in one command.
How it works
Type /month-abbr-axis, point it to your calendar table, and the skill builds everything:
Inspects the calendar table TMDL — detects partition type (M import or DAX calculated) and finds existing month columns
Creates an integer month column if one doesn't already exist
Adds the abbreviation column:
LEFT(FORMAT([Date], "mmm"), 1) & REPT(UNICHAR(8203), MONTH([Date]))withsortByColumnset to the integer month columnOptionally rewires the target chart's Category/X axis to use the new column with the correct
sortDefinition
What you get
MonthInitialcolumn (or custom name) — single-letter labels that are visually identical but internally uniquesortByColumnreference — chronological sort locked to the integer month column (1–12)Optional visual rewire — chart axis projection updated to
{AbbrevColumnName}with sort definition patched
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.

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.

