From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Calendar values on new card visual

Calendar values on new card visual - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Calendar values on new card visual

“

- [Instructor] Creating calendar visuals lets us visualize data trends within a month across date dimensions like days, weeks, and weekdays. Let's say we want to create a calendar visual within Power BI using the standard visual offerings, like the new card visual, which enables us to add measures to look like a table. When we create a calendar, we know we need to have seven columns for each weekday. We then add values to the calendar for all the potential placeholder days that any selected calendar month could have. The shortest month in the year is February, which has 28 days. This means we'll need a minimum of 28 placeholder days in our calendar. There are several months, however, with 31 days. This means we need at least 31 placeholder days if the month starts on a Sunday, which is our first day of the week. The first day of the month, however, doesn't often fall on Sunday. Instead, it often shifts to a later…

Contents