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.
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.
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?
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 👍🏻
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
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.
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.
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.
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.
Hello sir can you please make a dash board on stock market data . It would be really helpful.
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
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
Thank u so much, I hope all of your good deeds will be back to u as a best form ud ever receive, Aameen.
can you please share a link of the original source from where you got the data?
WHAT ARE THE INSIGHTS WE got .....can anyone can help me
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.
sir please make video on how to study data for dashboards and which columns from dataset should be used for representing on dashboards
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
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?
I am having problem in getting response time %
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 👍🏻
Thank you for the video. Simple yet impactful
Thank you for the video. I learnt a lot
Good one brother always following your vidoes kudos
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
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
You can use Format Painter option to make color customization easy and non repetitive.
@datatutorials1 i am notable to download the datasets of call center. can you plz upload and letus know thanks in adavance
FINISHED PRACTICING
Good Learning
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
thankyou, date formating me bhaut problem thi aur youtube ye kahi nahi ha thankyou you solve my problem
Thank you so much for this. I learned a lot!
Response time (%) formula is not correct
Love the dashboard, thank you for the step by step to make it.
How long can it take to create such a dashboard in a real-world environment?
Great
Sir novypro website m excel dashboard ko kese add krna h uspe video bnaiye na plzz.
Please make a detailed video on DAX
In progress
i will be expecting this as well sir. Thank you@@datatutorials1
my navigation is not working. what to do?
Perfect .......... I have learnt many things from this Dashboard...... Thanks Buddy Keet it up.
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
Please share the data link for CSV file
can i keep it in my resume please answer to me sir
please do videos on health care domain
Very impactful video
Do you also do one to one mentorship for Dashboard development? If yes please share contact details
Thanks a lot❤🎉
You're welcome 😊
There is no dashboard Excel sheet there is only data sheets provided
How many dashboard you have provide in your website
Thank you so much
I learnt a lot from the video it was very interesting.
Glad you liked
Plz do data cleaning in ms sql plz
UR DATA SHEET UNMATCH
Matching completely 💯
Pls can you drop the resources for the images
excellent dashboard, please keep making those amazing dashboard!
how to download shape map
Sir I'm not getting colour saturation in filled map visualizations tab. Please help
Use shape map instead
Hi Sir, do you take online classes for beginners
Excellent video, thanks sir 👍
GREAT VID THANKS!!
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?
Much appreciated 💗
Glad you liked it 👍🏻
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.
nice tutorial
Good learning experience thank you
Thanks for your effort
Woooow🎉
Thank you
Thankyou sir 😊
35:39
18:39
thank you
Nice ones 😉
Very Impressive..
Covered all the basics within short span.. Great tutorial.. Thanks a lot
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