Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Br1-981
Helper I
Helper I

Histogram with missing months

Hi,

I'm building a report using a DATA TABLE including a Date for each record.

I've created a CALENDAR TABLE using 

Calendar = CALENDAR(DATE(2019,1,1), DATE(2030,12,31))

and then 

YEAR = YEAR('Calendar'[Date])

MONTH = MONTH('Calendar'[Date])

MONTH_SHORT = FORMAT ( 'Calendar'[Date], "MMM" )

 

Br1981_0-1705935468988.png

 

Then I've connected the two tables and I'm trying to create a histogram but the problem is that using MONTH i have the full range across the year:

Br1981_1-1705935733992.png

 

while using the MONTH_SHORT I got:

Br1981_2-1705935779712.png

 

But I cannot understand why, my target is to use the MONTH SHORT but havnig the full range.

 

Thanks in advance 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Br1-981 

have you tried "show items with no data"?

11.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@Br1-981 

have you tried "show items with no data"?

11.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.