How to Make a Calendar Dashboard in Power BI
Вставка
- Опубліковано 22 лип 2024
- Join the waitlist for Power Query's M Language course↗️ - subscribepage.io/Learn_Power_...
Here in this video, you will learn how to present your data on the calendar! Although you have custom visuals available but in case you want to a native visual to act like a calendar,Watch this!
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/calendar-dashboa...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - Наука та технологія
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/
Thanks a lot! I use it for my birthday calendar and it looks “pretty awesome”
That looks great, I've been looking for something like this, thank you!
I always learn something new from you..Thanks a lot
Very cool, very inspired! Thank you so much!
Amazing, Thank you for sharing!😊
Amazing as always. Thanks for this advance tips and tricks.
This is super cool. Really creative and a great explanation. 👍
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 ❤
Hello Chandeep,
You are really good!
Kudos for the way you 'build the path' to the end result.
Thank you for sharing this tutorial.
Wow, brilliant Chandeep!
Creative ideas. Very nice
Thanks for this tutorial, very useful!!
wonderful one, thank you for sharing
Absolutely epic!!
Thanks, this is really great. One tip: you you use a tooltip with some extra remarks per event, that would also be helpful.
Amazing! Thank you.
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!
Excellent!!
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?
You are awesome 😊
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?
Helpful.
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.
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
😍 Gorgeous indeed!
Thank you Celia
hello
I can't sort by days of the week but they are organized alphabetically
Great tutorial. How can events spanning multiple days be displayed? Thanks in advance
How can I present these events on line chart with little flags referring to the events?
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
Great video, I need to replicate it so I can actually learn something out of it :)
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
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,"✅","❌")
Amazing! Did you source data from excel
Can power bi source data from outlook
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!
Hello Chandeep, one thing. What if I want different background colours for diffferent selection from slicer. How to achieve this ?
is there any way one can reach out to you for help in specific questions?
how about i’ve start date and end date? how i want to flash the end date too?
Amazing
But hoe did you remove the week number from the y axis.
That part is missing in this video
How do you ordenate all information?
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.
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.
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
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])
the email for the download link is blank - rip
goodly.co.in/wp-content/uploads/2023/09/Calendar-Dashboard-in-Power-BI.zip
The column headers i.e; the day are not being arranged in correct order in my matrix😢😢
sort by dayNo
Not work with month & year calneder… like you show day where I want to show year mad where week I want to show quarter
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])
The second part of the video was really superficial explained.
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.