Show items with No Data not working with Format Function

[lovishsood1]

Hello Everyone,

Problem: Not able to display "Show items with no Data" after changing the format of Month Name from "January" to "Jan".

Also, I tried creating a simple calculated column for changing the format of the Month. But still not able to get Blank Months.

I hope, You have understood my problem.

FYI ,

I need blank months but with MonthName in Short Form. Like above.

[lovishsood1 · Accepted solution]

I resolved it by taking a separate Date Table and linking it with the Date column of the Table and then taking the Month from the Date table in the chart.

Month = FORMAT('Calendar'[Date],"mmm") 

This resolved my problem.