Month Abbreviation Axis

Single-Letter Month Labels (JFMAMJJASOND)

Build

Featured Image

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:

  1. Inspects the calendar table TMDL — detects partition type (M import or DAX calculated) and finds existing month columns

  2. Creates an integer month column if one doesn't already exist

  3. Adds the abbreviation column: LEFT(FORMAT([Date], "mmm"), 1) & REPT(UNICHAR(8203), MONTH([Date])) with sortByColumn set to the integer month column

  4. Optionally rewires the target chart's Category/X axis to use the new column with the correct sortDefinition

What you get

  • MonthInitial column (or custom name) — single-letter labels that are visually identical but internally unique

  • sortByColumn reference — chronological sort locked to the integer month column (1–12)

  • Optional visual rewire — chart axis projection updated to {AbbrevColumnName} with sort definition patched

Tool Information

Price

20 USD

Category

Build

Version

Version 1.0.0.2.13