Short Month Names using DAX | Power BI Tutorial

In this video, I demonstrate how to efficiently shorten month names (e.g., January, February, March) to their abbreviated forms (J, F, M) in Power BI. This quick tip will help you customize your reports with cleaner, more compact month labels using UNICHAR. Whether you're working with date data or optimizing visual space, this trick can enhance your Power BI dashboards.
PBIX file: github.com/Sun...
#powerbitutorial #drivenbidata #DAX #DAXtutorials #DAXtips #powerbicharts #powerbitips #powerquery #powerquerytutorial #ExcelTips #PowerQuery #DataAutomation #ExcelTricks #visual formatting #businessintelligence #unichar #unicharinpowerbi

[@djaleleddineboussahel1501]

Good idea thanks

[@drivenBIdata]

Glad you find it useful!

[@zahir585]

Brilliant thx for sharing

[@drivenBIdata]

Glad you find it useful!

[@Srinivas_13]

Indeed, iterations each time,
Just extract first letter from month name column at power queryside which is more performance......
Try, this works

[@drivenBIdata]

Tried with Power Query and it works! Thanks for the comment. Here is the code to create "Custom Column"
let
MonthNumber = Date.Month([Date]),
MonthInitial = Text.Start(Date.ToText([Date], "MMM"), 1),
ZeroWidthSpace = Character.FromNumber(8203),
UniqueInitial = MonthInitial & Text.Repeat(ZeroWidthSpace, MonthNumber)
in
UniqueInitial

[@Back1Ply]

You can also do it in power query
// Added Month Name S (Special formatting for Month name)
#"Added Month Name S" = Table.AddColumn(#"Inserted Year Quarter", "Month Name S", each Text.Repeat(Character.FromNumber(8203), 12 - Date.Month([Date])) & Text.Start(Date.MonthName([Date]), 1), type text)