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
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" )
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:
while using the MONTH_SHORT I got:
But I cannot understand why, my target is to use the MONTH SHORT but havnig the full range.
Thanks in advance
Solved! Go to Solution.
have you tried "show items with no data"?
Proud to be a Super User!
have you tried "show items with no data"?
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |