Search code examples
powerbidaxpowerbi-desktop

Power BI :: Calendar Table doesn't have the calendar icon

I have a DAX code that can create a calendar table for me:

Calendar = 
ADDCOLUMNS (
    CALENDARAUTO(),
    "Calendar Year", YEAR ( [Date] ),
    "Month Name", FORMAT ( [Date], "mmmm" ),
    "Month Number", MONTH ( [Date] ),
    "Day", DAY ( [Date] ),
    "Quarter", "Q" & TRUNC ( ( MONTH ( [Date] ) - 1 ) / 3 ) + 1
)

Everything looks good, it's not even marked as date table but the result is perfect for me:

enter image description here

In another project I create the same calendar table, with the same code. As you can see:

  • Name
  • Data Type
  • Format
  • Summarization are all the same

...but in the and as you can see the calendar is not the same. I can mark it or not as calendar table but the icon will still be the same: not a calendar icon but the general icon.

enter image description here

And If I try to create a hierarchy it results in creating this empty stuff:

enter image description here

What am I doing wrong?

Solution

  • You're doing nothing wrong. The first one you have, the report has Time intelligence: Auto date/time switched on:
    enter image description here

    It is recommended that you switch this off when you are using your own Date table. So your second option is recommended. Now with Auto date/time switched off, you will need to build your own Hierarchy.

    Tip: For your Quarter column, you can use the QUARTER function:

    "Quarter", "Q" & QUARTER([Date])