How to Make a Calendar Dashboard in Power BI

[@GoodlyChandeep]

Download File ⬇ - goodly.co.in/calendar-dashboard-power-bi/ Learn more about my courses here - goodly.co.in/products

[@doublenico]

Hi, Impossible to downlaod the file, in the email received there is no link unfortunalty

[@GoodlyChandeep]

@doublenico I'll get it fixed.

[@GoodlyChandeep]

The issue has been resolved. There was a bug causing the error. Thanks for pointing it out. Download the file here - goodly.co.in/calendar-dashboard-power-bi/

[@jolumenicaaa]

Fantabulous job!!! I was searching for some similar alternative here in Brazil and I couldn't find it. Indians will dominate the world in some years, I'm sure. Thank you very much!

[@Bondoz007]

You read my mind! I work in HR and I've been working on a calendar to show Employee leave - this is perfect - thanks

[@TamerAHamid]

I've the same issue, appreciate to share with me how it is work @Bondoz007

[@windyfebbiayuni5581]

could u give me advice regarding this cause im on the same project too. my data have the starting date and end date for the leave

[@laiqmehdi8704]

Deserve much more than wt you're your persistence and dedication to teach us is next level and is helping us alot ...god bless you ❤

[@barttitulaerexcelbart9400]

Thanks, this is really great. One tip: you you use a tooltip with some extra remarks per event, that would also be helpful.

[@williamarthur4801]

This made a nice change for me, not a huge fan if visuals, I much prefer just dealing with a Matrix / table and figures, have you done anything re PBi formatting and the codes used?

[@rus1ickoff]

Thanks a lot! I use it for my birthday calendar and it looks “pretty awesome”

[@fabioberetta]

you're my personal hero!!! that's incredible work! just a question to make the calendar more readble: how is possible to "bold" some information in the box (eg. day number or budget)? is it possible?

[@amahroos]

The topic is very important, but unfortunately the explanation is for non-beginners, but for professionals. I was waiting for a comprehensive explanation, but what was presented is only a vision and not an executive explanation of the topic. Do you have a detailed explanation for a beginner from beginning to end? To execute tasks on calander. Thanks

[@asikotimer]

Thanks for this tutorial, very useful!!

[@marianopl1982]

This is brilliant ❤. I love this video, and it applies so much to some application visuals I needed to set up. Great job.

[@DavidWallach-n9b]

Great tutorial. How can events spanning multiple days be displayed? Thanks in advance

[@Grace4242]

Amazing! Did you source data from excel Can power bi source data from outlook

[@RasshmiGohill]

Can you make a detailed video for beginner to get this result please ?

[@arjumandansari2873]

thank you for posting this - I have one question, what's CurrentDay variable's source. part of the script that runs in the matrix cell: [CurrentDay] & REPT(UNICHAR(10),2) &. when I use it, I get a red underline, meaning not recognized.

[@schuylerschultz]

I have the same issue

[@schuylerschultz]

Had to do some searching, but he created a "New Measurement" under the Calendar Table with the following code in the measurement: CurrentDay = SELECTEDVALUE('Calendar'[Day])

[@maryjamessimons9251]

Very important detail! Thanks so much

[@theanimal5977]

Thank you for this detail! Very helpful!

[@IvanCortinas_ES]

Superb tutorial. Thank you for sharing it, Chandeep.

[@alwayssurprised6241]

Nice video, I was looking for this some time. Is it possible to show the each event separately? Assume I have income and expenses and I want to show them separately and I also want to show the cumulative position.

[@hermesjrd]

I always learn something new from you..Thanks a lot

[@gennarocimmino]

Hello Chandeep, You are really good! Kudos for the way you 'build the path' to the end result. Thank you for sharing this tutorial.

[@mrneveradullmoment]

Can you include excel sheets for examples of what our data sets should look like? It gets really confusing toward the middle but it's going good up to then!

[@kyawmyotun9646]

Amazing as always. Thanks for this advance tips and tricks.

[@vincentedwards6925]

Is there quick way to swap out the events for my own events, recieving errors when trying to data swap? Thanks!

[@darins]

I do a lot of Data Validation and checking for "missing days" of sales data is important. This visual looks even better if you set the value to Sales Present = IF(ABS([InvoiceQuantity])>0,"✅","❌")

[@giorgiotrapletti681]

hello I can't sort by days of the week but they are organized alphabetically

[@theanimal5977]

I am having the same problem😢

[@NezzyLawd]

@@theanimal5977 You need to create a separate column in your Calendar. Call it something like Day Sort which will look like WEEKDAY([Date], 2). Once you have done that, go to the Week Day column in the table and then go to the Column Tools tab > Sort > Choose the Day Sort column. Monday will be represented as 1, Tuesday as 2 and so on. So your Days on the Week will be sorted.

[@chrislee232445]

@@theanimal5977 Go to Date table's table view, select "Days of the week" column, then go to column tools, select sort by column "Day No" (the column indicating Monday as 1, till Sunday as 7), then it will sort from Monday to Sunday It can be extended to Month as well, for those month sorting Alphabetically, you will need to create an "Index" to indicate Jan as 1 till Dec is 12, and select the "month" column sort by column "Index"

[@shubhamchaudhari1212]

Hello Chandeep, one thing. What if I want different background colours for diffferent selection from slicer. How to achieve this ?

[@Evaldas65]

That looks great, I've been looking for something like this, thank you!

[@valeriesoliman8334]

is there any way one can reach out to you for help in specific questions?

[@kwanhangcheung691]

Creative ideas. Very nice

[@ArvindKumar-he4on]

Hi, How you use [currentday]. This column is not available in table

[@sudokuchallenger7333]

yes exactly, I am also stuck there

[@ryanlundahl2979]

Create a measure that displays current day number@@sudokuchallenger7333

[@mrneveradullmoment]

I guess we shall never know!

[@marksearle1209]

@@mrneveradullmoment you create a measure in the calendar table with the DAX CurrentDay = SELECTEDVALUE('Calendar'[Day]) I only found out by downloading the pbix which he's put underneath the video - it wasn't explained fully in the video.

[@chrism9037]

Wow, brilliant Chandeep!

[@stefankirst3234]

Very cool, very inspired! Thank you so much!

[@edwinarchico439]

Amazing, Thank you for sharing!😊

[@mrneveradullmoment]

Amazing! Thank you.

[@unnikrishnansanthosh]

wonderful one, thank you for sharing

[@adamgsmith4777]

This is super cool. Really creative and a great explanation. 👍

[@jovelynbriones2466]

Is it possible to have more than 1 year? Like 2024 to 2025?

[@IkMag]

This is a nice way for a calendar. Unfortunately, there is a problem when using the ISO week number for each row. With January 1st after Wednesday for ISO the week number is the last week of the previous year. So, when I select the Januari for 2023, the week numbers are 1 up to 5 and 52 for the 1st only.

[@IkMag]

I solved my problem with an extra column in my calendar table: "WeekTxt" , CONCATENATE( CONCATENATE( MOD(year([date]) - IF(AND(WEEKNUM([date],21)>50,day([Date])

[@chrislee232445]

@4:45 where did [CurrentDay] come from? lost there

[@mohammedsuraif548]

How can I present these events on line chart with little flags referring to the events?

[@indianarasantos2798]

How do you ordenate all information?

[@mnedix]

Great video, I need to replicate it so I can actually learn something out of it :)

[@samanthapikus3178]

Excellent!!

[@CeliaAlvesSolveExcel]

😍 Gorgeous indeed!

[@GoodlyChandeep]

Thank you Celia

[@anilkapkoti296]

Amazing But hoe did you remove the week number from the y axis. That part is missing in this video

[@BISimplifier]

Absolutely epic!!

[@ozerius76]

Helpful.

[@azeemsk1653]

Hello , I'm having a small issue like the Matrix cells are showing me the day number only for month starting and month end dates..for in between it is not showing day number in matrix cells.... I have followed the same steps which you guided in video and also i have checked the pbix but unable to find the issue... This is because of we are having multiple years data that why it not showing correctly in day number in cells. How to over come this issue in case of having multiple years data. Thanks in advance.

[@magnodiniz99]

I had the same problem; I fixed it by creating a new column 'data,' just with the dates, excluding time, and relating it to the 'dcalendar' data.

[@farissmskml342]

how about i’ve start date and end date? how i want to flash the end date too?

[@sollapalooza]

how do you get the calendar slicer to appear in order and not alphabetically?

[@theanimal5977]

Go to table view -> Add another line in Calendar: "MonthNo",Month([date]) -> click on the Month column -> use Sort by Column -> select MonthNo that you just created

[@ricardoabella867]

How do you calculate CURRENTDAY thank you

[@GoodlyChandeep]

=SELECTEDVALUE(Calendar[DayofMonth])

[@rezashah326]

why my calendar table start from Sun, Mon, Sat, Wed, Thu, Fri. How to fix it to get same like you Mon, Tue, Wed, Thu, Fri, Sat, Sun?

[@barthjdc]

You have to go to the table, select the column DayName and sort it with DayNo

[@martyns1722]

How to do this on excel

[@saisatya5525]

You are awesome 😊

[@windyfebbiayuni5581]

what if my data is in range and not a single value? i have the starting date and end date for this

[@megabuilds3007]

What is Current Date?

[@GoodlyChandeep]

Day of the month

[@megabuilds3007]

@@GoodlyChandeep Yes got that, thank you. I've just created myself on own by watching your video. Finaly one doubt, what if we have multiple tasks on single date? Not more maybe 2 or 3?

[@schuylerschultz]

Had to do some searching, but he created a "New Measurement" under the Calendar Table with the following code in the measurement: CurrentDay = SELECTEDVALUE('Calendar'[Day])

[@shonwilson5219]

The column headers i.e; the day are not being arranged in correct order in my matrix😢😢

[@mizanadilah125]

sort by dayNo

[@LisaR-bb8zs]

This isn't for beginners. Lots of steps missed out and there's assumption you're familiar with Power BI already. Shame as it started off good!

[@mrneveradullmoment]

Right! It was going great until suddenly we were throwing events on the calendar from thin air. Ha! He's awesome but def not for beginners.

[@roberttyler2861]

the email for the download link is blank - rip

[@GoodlyChandeep]

goodly.co.in/wp-content/uploads/2023/09/Calendar-Dashboard-in-Power-BI.zip

[@klebersanto50]

The second part of the video was really superficial explained.

[@abhijeetshetye8785]

Not work with month & year calneder… like you show day where I want to show year mad where week I want to show quarter

[@theanimal5977]

Looks possible, but if you actually followed his steps, you will find many details information that could have been mentioned in the video. Felt like those information are being left out on purpose ... Very frustrating