Hi Arvi, I will try to create one soon. I haven't created excel dashboard yet before, it's first time for me...so need to try that, then will upload. Thanks
@vipulshukla1674 Жыл бұрын
i just recently start to watch your video its help me lot thanku so much & keep on guide us ..
@mukesh_lovers Жыл бұрын
Which institute is good for Learn Data Analyst..
@TravelridewithPRINCE Жыл бұрын
How to download ma'am
@BasicTechConceptsBySaloni Жыл бұрын
Click on link given in description -> Go to File -> Click download -> choose format to download : excel
@beingrishi6450 Жыл бұрын
The month and week wise should be given parallel like from Jan to Dec and Mon to Sun...
@mdsajadulislamdipu7395 Жыл бұрын
How can I do this can you share me please?
@beingrishi6450 Жыл бұрын
@@mdsajadulislamdipu7395 you need to create measure for calender date = CALENDAR ("01/01/2023","31/12/2023"). As it is very important for KPIs and Gauge visuals to see how the company is performing currently compared to last sales and profit. So for example, in order to make a month's measure to see a product sale , we have to create a Month Name=FORMAT ( Calendar [Date], "mmmm"). But while when we create one custom visual like Stacked bar chart 📊 Area chart or line chart 📈, PowerBI will automatically show the result of month wise product sales in alphabetical order like A to Z.. which means April, August, December, February, January, June, July, March, May, November, October, September. This is the wrong analysis. So we need to create measure Month number = MONTH(Calendar [Date]) which will show from 1 to 12 considering 1 as January till 12 as December. In PowerBI there are 3 views, Report, Data, Model, so click on Data view you will be able to see month name and month number. Click on month name measure then in ribbon toolbar you will see SORT BY COLUMN section click on inside you will see month number, click on it. Then month name will get sorted by month number and the visual of month by product sales will show from January to December. Same applies for year quarter and week as well...!
@shahidabrahamfan6125 Жыл бұрын
video acha hai , or aap apna video mai awaj kisi baby ka awaj mai q change ki ho
@akashrawat5596 Жыл бұрын
I am unable to edit the data as it is protected by you!
@BasicTechConceptsBySaloni Жыл бұрын
You have to download the data, go to File -> Click download.
@akashrawat5596 Жыл бұрын
@@BasicTechConceptsBySaloni thanks got it.
@asp4628 Жыл бұрын
@@BasicTechConceptsBySaloni madam I am arable download your file.
@Rational_openion Жыл бұрын
Thank you for the project. I am a beginner and I'm learning new things from your lectures. Could you please provide your email ID so that I can reach out to you and clarify my doubts?