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/
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!
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.
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])
@@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.
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?
@@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.
@@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"
Use the column tools' "Sort by column" feature (click the DayName column in the data to bring up the column tools menu. Then, select DayNo by clicking on "Sort by column").
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?
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
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.
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!
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
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.
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,"✅","❌")
@@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?
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])
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.
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])
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
Download File ⬇ - goodly.co.in/calendar-dashboard-power-bi/
Learn more about my courses here - goodly.co.in/products
Hi,
Impossible to downlaod the file, in the email received there is no link unfortunalty
@doublenico I'll get it fixed.
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/
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!
You read my mind! I work in HR and I've been working on a calendar to show Employee leave - this is perfect - thanks
I've the same issue, appreciate to share with me how it is work @Bondoz007
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
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.
I have the same issue
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])
Very important detail! Thanks so much
Thank you for this detail! Very helpful!
Is there quick way to swap out the events for my own events, recieving errors when trying to data swap? Thanks!
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 ❤
Hi, How you use [currentday]. This column is not available in table
yes exactly, I am also stuck there
Create a measure that displays current day number@@sudokuchallenger7333
I guess we shall never know!
@@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.
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?
hello
I can't sort by days of the week but they are organized alphabetically
I am having the same problem😢
@@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.
@@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"
Use the column tools' "Sort by column" feature (click the DayName column in the data to bring up the column tools menu. Then, select DayNo by clicking on "Sort by column").
@@dhinsha5415 it works! Thank you
Thanks for this tutorial, very useful!!
@4:45 where did [CurrentDay] come from?
lost there
@chrislee232445 [CurrentDay] = SELECTEDVALUE(Date[Day])
Thanks, this is really great. One tip: you you use a tooltip with some extra remarks per event, that would also be helpful.
Thanks a lot! I use it for my birthday calendar and it looks “pretty awesome”
Superb tutorial. Thank you for sharing it, Chandeep.
I always learn something new from you..Thanks a lot
This is brilliant ❤. I love this video, and it applies so much to some application visuals I needed to set up. Great job.
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?
Hello Chandeep,
You are really good!
Kudos for the way you 'build the path' to the end result.
Thank you for sharing this tutorial.
is there any way one can reach out to you for help in specific questions?
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
Amazing as always. Thanks for this advance tips and tricks.
Amazing! Did you source data from excel
Can power bi source data from outlook
Wow, brilliant Chandeep!
Great tutorial. How can events spanning multiple days be displayed? Thanks in advance
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.
How can I present these events on line chart with little flags referring to the events?
Creative ideas. Very nice
Hello Chandeep, one thing. What if I want different background colours for diffferent selection from slicer. How to achieve this ?
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!
How do you ordenate all information?
That looks great, I've been looking for something like this, thank you!
Can you make a detailed video for beginner to get this result please ?
how about i’ve start date and end date? how i want to flash the end date too?
Very cool, very inspired! Thank you so much!
Amazing, Thank you for sharing!😊
wonderful one, thank you for sharing
This is super cool. Really creative and a great explanation. 👍
😍 Gorgeous indeed!
Thank you Celia
how do you get the calendar slicer to appear in order and not alphabetically?
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
How to do this on excel
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.
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.
Amazing! Thank you.
How do you calculate CURRENTDAY thank you
=SELECTEDVALUE(Calendar[DayofMonth])
Excellent!!
Absolutely epic!!
Amazing
But hoe did you remove the week number from the y axis.
That part is missing in this video
what if my data is in range and not a single value? i have the starting date and end date for this
You are awesome 😊
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,"✅","❌")
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?
You have to go to the table, select the column DayName and sort it with DayNo
Helpful.
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!
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.
The column headers i.e; the day are not being arranged in correct order in my matrix😢😢
sort by dayNo
What is Current Date?
Day of the month
@@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?
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])
Is it possible to have more than 1 year? Like 2024 to 2025?
the email for the download link is blank - rip
goodly.co.in/wp-content/uploads/2023/09/Calendar-Dashboard-in-Power-BI.zip
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.
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])
Great video, I need to replicate it so I can actually learn something out of it :)
Not work with month & year calneder… like you show day where I want to show year mad where week I want to show quarter
The second part of the video was really superficial explained.
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