Power BI: create a calendar visual

The easier way to create a visual for a calendar will be to download some paid/free visuals that I can find in the market. In this article, I will show you how to do it without any additional tools.

power bi

First, I have created this 2025 calendar table:

power bi

NOTE: to know how to, read Power BI: create an automatically updated calendar

Next, I will add 7 new columns by clicking on “table tools -> new column”:

power bi

Delete everything then put:

  • For the first one: daynumber = DAY([calendar])
    power bi
  • For the second one: dayname = FORMAT([calendar],"DDD")
    power bi
  • For the third one: weekdaynum = WEEKDAY([calendar],2)
    power bi NOTE: the “2” means that my calendar will start with Monday
  • For the fourth one:

weekmonth = var startmonth = DATE(YEAR([calendar]),MONTH([calendar]),1)
var endmonth = EOMONTH([calendar],0)
var newcalendar = ADDCOLUMNS(CALENDAR(startmonth,endmonth),"week",WEEKDAY([Date],2))
// NOTE: the “2” means that my calendar will start with Monday
return
COUNTROWS(FILTER(newcalendar,[Date]<[calendar] && [week]=7))+1
                
power bi
  • For the fifth one: weekyear = WEEKNUM([calendar],2)
    power bi NOTE: the “2” means that my calendar will start with Monday
  • For the sixth one: monthname = FORMAT([calendar],"MMMM")
    power bi
  • For the last one: monthnum = MONTH([calendar])
    power bi

NOTE: if you want your calendar to start with another day, for instance Sunday, change the 3 “2” by “1”, all 3 should have the same number. For more options, read:

Before to create my visual, I will need to sort correctly those columns by clicking on “column tools -> sort by column”:

  • The day name to select “weekdaynum”
    power bi
  • The month name to select “monthnum”
    power bi

In the “visualizations” panel, I will choose “matrix” then those columns in those fields:

power bi power bi

For “values”, click on the “down arrow” to select “minimum”:

power bi power bi

The visual will look like this:

power bi

To remove both “totals”, click on “format your visual” then turn off those options:

power bi power bi

I will create a slicer with “monthname”:

power bi

And in the “slicer settings”, I will choose this option:

power bi

This is the result:

power bi

In my calendar, I can add some information, for instance, I have another table like that:

power bi

NOTE: there is an active relationship between my 2 tables

I am going to add “comment” in “values”:

power bi

In “format my visual”, I will configure those 3 options:

power bi power bi power bi

My visual will look like this:

power bi

I will reduce the size of the “weekyear” column to get this result (just place the mouse above the vertical blue line, the mouse icon will change then left click and hold to move it to the right):

power bi

Also I can put some colors, put the values in the center, etc. to get for instance this final result:

power bi

Just play with the different configurations to customize it as you like.

Interesting Topics