Download File ⬇ - goodly.co.in/calendar-dashboard-power-bi/ Join the waitlist for Power Query's M Language course↗ - subscribepage.io/Learn_Power_Querys_M_Language
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!
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
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])
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?
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!
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,"✅","❌")
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?
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.
@@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 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])
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.
@@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])
Download File ⬇ - goodly.co.in/calendar-dashboard-power-bi/
Join the waitlist for Power Query's M Language course↗ - subscribepage.io/Learn_Power_Querys_M_Language
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/
Superb tutorial. Thank you for sharing it, Chandeep.
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!
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
This is brilliant ❤. I love this video, and it applies so much to some application visuals I needed to set up. Great job.
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 ❤
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
Hello Chandeep,
You are really good!
Kudos for the way you 'build the path' to the end result.
Thank you for sharing this tutorial.
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”
Amazing as always. Thanks for this advance tips and tricks.
I always learn something new from you..Thanks a lot
Thanks for this tutorial, very useful!!
This is super cool. Really creative and a great explanation. 👍
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
hello
I can't sort by days of the week but they are organized alphabetically
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?
That looks great, I've been looking for something like this, thank you!
Amazing! Thank you.
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!
Wow, brilliant Chandeep!
Very cool, very inspired! Thank you so much!
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,"✅","❌")
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?
Creative ideas. Very nice
Amazing, Thank you for sharing!😊
Amazing! Did you source data from excel
Can power bi source data from outlook
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.
Great tutorial. How can events spanning multiple days be displayed? Thanks in advance
Helpful.
Hello Chandeep, one thing. What if I want different background colours for diffferent selection from slicer. How to achieve this ?
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.
Great video, I need to replicate it so I can actually learn something out of it :)
wonderful one, thank you for sharing
Absolutely epic!!
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.
Excellent!!
😍 Gorgeous indeed!
Thank you Celia
is there any way one can reach out to you for help in specific questions?
You are awesome 😊
Amazing
But hoe did you remove the week number from the y axis.
That part is missing in this video
How can I present these events on line chart with little flags referring to the events?
How do you ordenate all information?
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])
how about i’ve start date and end date? how i want to flash the end date too?
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.
How to do this on excel
How do you calculate CURRENTDAY thank you
=SELECTEDVALUE(Calendar[DayofMonth])
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
The second part of the video was really superficial explained.
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])
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 email for the download link is blank - rip
goodly.co.in/wp-content/uploads/2023/09/Calendar-Dashboard-in-Power-BI.zip