Hello everyone, there might be date format errors in csv file I shared, i suggest all of you to change the data type of date field when you connect power bi to the csv file. This will resolve your issues. Also i will share excel xlsx file where you can download using same link description box which will have correct date format.
hello sir....thankyou for your valuable information. recently i have graduated and searching for BI analyst job. meanwhile i have learnt power bi, mssql, msexcel. please give a better solution for my career sir.
Bro you made a video on a prohwct ovwrview which consisted in sql and power bi about 2 months ago a black theme power bi report when is that video coming out Great project is superb as well 👍🏻
From the power query editor pane, right click and select “change type” then select “using Locale” and change data type to “date” and locale to “English UK” Once you do this you are good to go Give me feedback
@@Ajha1237 1) Go power Query change timestamp datatype from text into Date 2) Go to file select options &setting then options then go to current file change the regional setting into ENGLISH UK
Sir please make a video to solve the problem - when i want to draw map it will just blank I search for it various platforms but this blank map problem not solved yet.
thank you so much, but could you please make a dashboard on sea cargo it related to and also one in agricultural business. i am curious as to how analysis can be done in this field. thank a bunch sir.
When I tried to sort the column chart with the created “Day No” I keep getting an error message “A circular dependency was detected: Date Table[Day], Date Table[Date No], Date Table[Day].” Please I need help
Hii response time % pe error de raha sir a function placeholder has been in true /false expression that is used as table filter expression .please ans. how i can solve this?
It looks like a data quality issue with the source csv. In my case, the call timestamp column data type was text. 1st I changed it to date then I had 61% errors in that column. I changed the local to English(UK) , now no more errors and that was the fix.
While plotting total calls by day in column chart im seeing all the datas are same for all the days how to fix this issue can anyone please help me with this 45:51
Hi make sure that your date column is in correctly date data type in power bi. if it’s in text or other format try to change the data type to date format. Hope this helps.
Hello everyone, there might be date format errors in csv file I shared, i suggest all of you to change the data type of date field when you connect power bi to the csv file. This will resolve your issues. Also i will share excel xlsx file where you can download using same link description box which will have correct date format.
How do we change that pls i have tried to do that but getting the same thing
there is an error even when i change the data type of date field
hello sir....thankyou for your valuable information. recently i have graduated and searching for BI analyst job. meanwhile i have learnt power bi, mssql, msexcel. please give a better solution for my career sir.
Thank u so much, I hope all of your good deeds will be back to u as a best form ud ever receive, Aameen.
Love the dashboard, thank you for the step by step to make it.
thankyou, date formating me bhaut problem thi aur youtube ye kahi nahi ha thankyou you solve my problem
Very impactful video
Thank you for the video. Simple yet impactful
Great
Good Learning
sir please make video on how to study data for dashboards and which columns from dataset should be used for representing on dashboards
Hello sir can you please make a dash board on stock market data . It would be really helpful.
Thank you for the video. I learnt a lot
Thank you so much
I learnt a lot from the video it was very interesting.
Glad you liked
Perfect .......... I have learnt many things from this Dashboard...... Thanks Buddy Keet it up.
You can use Format Painter option to make color customization easy and non repetitive.
Thank you so much for this. I learned a lot!
FINISHED PRACTICING
Good one brother always following your vidoes kudos
excellent dashboard, please keep making those amazing dashboard!
Covered all the basics within short span.. Great tutorial.. Thanks a lot
Bro you made a video on a prohwct ovwrview which consisted in sql and power bi about 2 months ago a black theme power bi report when is that video coming out
Great project is superb as well 👍🏻
Woooow🎉
Excellent video, thanks sir 👍
Good learning experience thank you
Thanks for your effort
Thanks a lot❤🎉
You're welcome 😊
GREAT VID THANKS!!
Excellent in real time with problem statement they mention charts which chart as to use ?
Requirements they do provide, what charts to use that depends on client but sometimes yes sometimes no
Much appreciated 💗
Glad you liked it 👍🏻
Thank you
While doing the total calls by day ........Iam not able to see any days in my x axis . I am only seeing one column .
Yes..i am also facing same issue
From the power query editor pane, right click and select “change type” then select “using Locale” and change data type to “date” and locale to “English UK”
Once you do this you are good to go
Give me feedback
You are correct
Same issue I had faced can someone help me how to check with the power query editor
@@Ajha1237 1) Go power Query change timestamp datatype from text into Date 2) Go to file select options &setting then options then go to current file change the regional setting into ENGLISH UK
Sir please make a video to solve the problem - when i want to draw map it will just blank I search for it various platforms but this blank map problem not solved yet.
thank you so much, but could you please make a dashboard on sea cargo it related to and also one in agricultural business. i am curious as to how analysis can be done in this field. thank a bunch sir.
Please provide data analysis sample resumes
I learn SQL, Power bi, excel
hi, this is amazing
Glad it helped you
Bro, a proble here, when i create date table then show time 12:00 am, and then i creat Day column it show error?
Very Impressive..
Thankyou sir 😊
can you please share a link of the original source from where you got the data?
nice tutorial
Please make a detailed video on DAX
In progress
i will be expecting this as well sir. Thank you@@datatutorials1
Nice ones 😉
please do videos on health care domain
i am facing a problem while making this Dashboard, Error Occurs when i am selecting Total call duration ??? why if anyone pls explain it to me
Same here is not working
@datatutorials1 i am notable to download the datasets of call center. can you plz upload and letus know thanks in adavance
When I tried to sort the column chart with the created “Day No” I keep getting an error message “A circular dependency was detected: Date Table[Day], Date Table[Date No], Date Table[Day].” Please I need help
Hi sir I facing some issue in date section my date column in alphabetical order and when I change the type its show Error.
You should check with your local date and time
Thanks for lecture , I too created this Dashboard but my navigation tab is not working, any suggestion Please ?
Did you take navigation button to create, try pressing alt and click
Sir novypro website m excel dashboard ko kese add krna h uspe video bnaiye na plzz.
Hii response time % pe error de raha sir a function placeholder has been in true /false expression that is used as table filter expression .please ans. how i can solve this?
How long can it take to create such a dashboard in a real-world environment?
Plz do data cleaning in ms sql plz
I am having problem in getting response time %
Sir I'm not getting colour saturation in filled map visualizations tab. Please help
Use shape map instead
Do you also do one to one mentorship for Dashboard development? If yes please share contact details
Hi Sir, do you take online classes for beginners
can i keep it in my resume please answer to me sir
How many dashboard you have provide in your website
There is no dashboard Excel sheet there is only data sheets provided
WHAT ARE THE INSIGHTS WE got .....can anyone can help me
Please share the data link for CSV file
Pls can you drop the resources for the images
my navigation is not working. what to do?
how to download shape map
I'm facing a problem while creating the column chart while adding the day column, it is showing as blank can you please address me.
I'm also facing this problem. 😢
I've figured it out, check with your locale time zone settings which has to be matched with the dataset which we are using @@_rex.uxchiha5721
Send you issue with screenshot on my WhatsApp number available in description of video
It looks like a data quality issue with the source csv. In my case, the call timestamp column data type was text. 1st I changed it to date then I had 61% errors in that column. I changed the local to English(UK) , now no more errors and that was the fix.
@@healthy_ches yes I have done the same my timezone was us and changed it to UK then it’s fine
While plotting total calls by day in column chart im seeing all the datas are same for all the days how to fix this issue can anyone please help me with this 45:51
do u get the solution plzz i need help
Hi make sure that your date column is in correctly date data type in power bi. if it’s in text or other format try to change the data type to date format. Hope this helps.
35:39
Response time (%) formula is not correct
UR DATA SHEET UNMATCH
Matching completely 💯
thank you
18:39