Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our TH-cam channel 👉Please ping on WhatsApp wa.me/9916961234
The reason you typically need to add a "Month Order" column (especially in tools like Power BI) to sort months in a slicer is that, by default, a month name column (e.g., "January," "February," etc.) is treated as text. Text columns are sorted alphabetically (i.e., April, August, December, etc.) rather than in chronological order (January, February, March, etc.). Why Can’t We Simply Sort by Month Name? Alphabetical Sorting: Without a numeric value, month names are sorted alphabetically. So, the default sorting for a slicer or visual will be something like this: April, August, December, February, January, etc. No Natural Chronological Order: Since the month names are strings, there’s no inherent understanding in the system about their order in the calendar year (i.e., "January" comes before "February"). Solution: Adding a "Month Order" Column To correctly sort month names in chronological order, you need to add a "Month Order" column with corresponding numeric values (e.g., 1 for January, 2 for February, etc.). Here’s why this works: Numeric Sorting: The slicer or chart will use the "Month Order" column to sort months properly (1 = January, 2 = February, etc.) instead of sorting them alphabetically. Flexibility: This allows you to display the month names in the correct order, but behind the scenes, they are sorted based on the "Month Order" values
Hi sir, I've a query regarding Line Chart which you did in this video, I've done everything as is, but i don't know where is the mistake Line chart values of QUARTER is showing only Q-1 bar other than quarter 1 no other quarters are showing, could you please give me any suggestions..
Hi mamidi Aditya Thanks for reaching out! It sounds like the issue might be related to how the data is grouped or how the quarters are being filtered in your dataset. A few things to check: Ensure that all quarter values (Q1, Q2, Q3, Q4) are properly present and formatted in your data source. Check if there’s any filter applied that might be limiting the display to just Q1. Verify that your X-axis is set to show all quarters, not just a subset. If these don’t resolve the issue, feel free to share more details or screenshots, and I’d be happy to assist further! Best regards, Team KSR
sir in the line chart for me why it is showing only for qtr 2 and hence showing straight line?(35.57) and also when iam pasting the date and avg of total revenue table in from page 3 to page 1 its not showing the complete list i mean scrolling is not happening
I followed same steps for QoQ growth percentage, I eve got the same results in table. Bu as soon as I plot in line chart, it is giving sum total of each year's quarter in chart (eg: for 1st qtr of all year the sum is 30635916.50) So it is showing this value in chart.Also it is adding up the percentage and showing infinity in chart... where did I make mistake...?
sir excellent superb sir realally i enjoy the class verry verrryyyyyyyy tq sir good thoughts for all students .....i get more knowedge only for u tq ...share the one more project sir .....all members gain more information in real time project whats happend in real time
Hi sir, the video is really great. I just had one doubt. To identify the top 5 employees based on the gross profit using cards, I did everything as shown in the video. However once the filter is applied the card is going blank. Can you please help me with this? Thanks in advance
There are a couple of reasons why your card might be showing blank after filtering for the top 5 employees based on gross profit: Empty Ranking Column: In the video, it's likely they created a calculated column to rank the employees based on gross profit. Ensure you've created a similar ranking column in your Power BI. This column can be a simple formula like RANKX(ALL(YourTable), [Gross Profit], DESC, DENSE). Use the correct table name and replace [Gross Profit] with your actual gross profit column name. Filter Context: Power BI filters can sometimes interact unexpectedly. When you apply a filter to see the top 5 employees, other filters might be unintentionally affecting the results. Try creating a separate page or visual specifically for the top 5 employees. This can help isolate the context and ensure the card displays the correct value. Data Aggregation: Make sure your card visual is configured to show the correct aggregation of the top 5 ranking. It should likely be set to "Top" or "Max" to display the highest gross profit among the top 5 employees. Here's a breakdown of troubleshooting steps: 1. Check Ranking Column: Go to your table and ensure the ranking column exists and has values for all employees. 2. Isolate the Top 5: Create a new page or visual. In the Filters pane, apply the filter for "Top N by [Ranking Column] = 5". This will ensure only the top 5 ranked employees are considered. Now add your card for displaying the top gross profit. It should show the correct value. 3. Verify Card Aggregation: Click on the card visualization. Go to the formatting options for the card. Under "Value", ensure the aggregation is set to "Top" or "Max" to display the highest gross profit. Additional Tips: Double-check the data types of your columns. Inconsistent data types can lead to unexpected results. Use the "Preview" feature in Power BI to see how filters and calculations will affect your visuals before applying them. If you're still facing issues, consider sharing a screenshot of your Power BI setup (without sensitive data) for further assistance. By following these steps and checking your configuration, you should be able to resolve the blank card issue and display the top gross profit for the top 5 employees.
Hi Sir,, at 31:03 for total revenue I am getting error its not being displayed I used don't summarize also but the its not getting displayed can you plz help to provide the solution for this/.
Hello Sir, First of all, thank you for this wonderful Power bi series but I have a couple of questions that are why you have used different shades of blue in the pie chart instead of RGB colours @16:47, is it reflect some sort of professionalism, why you have created tot rev measure when you total revenue column to use in calculate function @30:43 and also why you have to change the background colour of date field in last visual, can be left it uncoloured also @42:55?
Thanks for the message. Report should be always with limited colors. Shades gives you good readability and neatness. Measures are generic functions, which can be used for other visuals. Its always good practice to write measures for key numbers. Background was optional. we have kept for good design.
Hi, just wanted to know when i drag any calculated Columns it renames the columns as Sum of that value. for eg while dragging total revenue for waterfall chart in Y axis it renamed it to SUM of total revenue, but for you its not changing, it is coming as it is. can you please help me out with this. i don't want the column name to be renamed while dragging.to some aggregate functions.
Even I'm facing the same issue. The values for Total Revenue based on quarter in the table chart are different from what you are getting. Additionally, if I follow the remaining steps , I am getting the QoQ growth in negative percentage. Kindly help
Hello Sir, first of all thank you for amazing project and work. I have a doubt. While making line graph, I am unable to get normal revenue, somehow its getting adding up and I don't know how to get the data as we got into the table which you showed in sheet 2. please help, sir
@@laxmannegi8886 hey man , yes I did resolve it . While making graphs sir has chosen a particular year hence it looks different. If you choose some year from drop down list then it will also come for you
@@ParthPandey-vl3wj when i m dragging total revenue to the table it is showing the total revenue same in every cell,i m not getting quater wise revenue
Thank you for your kind words! It's always encouraging to hear that my efforts are appreciated. Please subscribe our channel, it helps us to motivate to make more videos.
Hi, In line chart TotalRevenue and QoQ growth by Qtr , i am unable to draw the same graph which shown in this video. In X-axis taken Qtr and Y-axis Total revenue, in this case graph should show sum of all years qtr revenue, how it shows without showing year value. I am getting sum of all.
HI...am unable to find out more visuals...it is asking for organisational mail ID. how can we overcome that and download scroller visual? Please help me out
That's high praise! I'm glad you appreciated the depth and detail in the video. It's important to me that viewers get a thorough understanding of the topic. Thank you for watching the series. If you have any other questions or would like more information on this topic, please feel free to ask.
I have one query, Here you used total rev & previous quarter ( calendar master (date) ) for calculating QOQ Growth Instead of that, can we use current - previous? Yes or no??
hi , i am practicing with this data whenever im using category data special is showing but general is not showing for general it showing blank i checked the relation every thing but it showing blank for General can you please suggest me what to do
Sir, Am getting an error in date format. it gives the message like "we couldn't parse the input provided as a Date value. In sales sheet. Pls guide me how to fix it.
You are most welcome, please do share in your network and visit our website. www.datavizon.com/s/store/courses/description/KSRPowertoolJune2022?TH-cam&Video&Endtoendproject
Learned a lot from this series. Highly appreciated and thanks a lot.. I have a one question. Why did you create a measure called 'Tot profit'(at @37:43)? Already there is an existing column called "Gross Profit". So did u create an extra measure? cant we use the "Gross Profit" Column to create a 'previous month profit'(@38:23) measure instead of 'Tot profit' Measure?
Hi sir, As the requirement 3.7 Breakdown analysis, what if I choose month or Country will that impact waterfall visual, if yes Does it met the requirement? Please answer..............
Waterfall chart is best suited for breakdown analysis. As per requirement, they have asked for product breakdown analysis. So we have implemented. (we can use month or country as well)
Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our TH-cam channel 👉Please ping on WhatsApp wa.me/9916961234
Why cant we simply sort month slicer by MONTH (giving the same result) instead of adding MONTH ORDER column?
The reason you typically need to add a "Month Order" column (especially in tools like Power BI) to sort months in a slicer is that, by default, a month name column (e.g., "January," "February," etc.) is treated as text. Text columns are sorted alphabetically (i.e., April, August, December, etc.) rather than in chronological order (January, February, March, etc.).
Why Can’t We Simply Sort by Month Name?
Alphabetical Sorting: Without a numeric value, month names are sorted alphabetically. So, the default sorting for a slicer or visual will be something like this: April, August, December, February, January, etc.
No Natural Chronological Order: Since the month names are strings, there’s no inherent understanding in the system about their order in the calendar year (i.e., "January" comes before "February").
Solution: Adding a "Month Order" Column
To correctly sort month names in chronological order, you need to add a "Month Order" column with corresponding numeric values (e.g., 1 for January, 2 for February, etc.). Here’s why this works:
Numeric Sorting: The slicer or chart will use the "Month Order" column to sort months properly (1 = January, 2 = February, etc.) instead of sorting them alphabetically.
Flexibility: This allows you to display the month names in the correct order, but behind the scenes, they are sorted based on the "Month Order" values
Hi sir, I've a query regarding Line Chart which you did in this video, I've done everything as is, but i don't know where is the mistake Line chart values of QUARTER is showing only Q-1 bar other than quarter 1 no other quarters are showing, could you please give me any suggestions..
Hi mamidi Aditya
Thanks for reaching out! It sounds like the issue might be related to how the data is grouped or how the quarters are being filtered in your dataset. A few things to check:
Ensure that all quarter values (Q1, Q2, Q3, Q4) are properly present and formatted in your data source.
Check if there’s any filter applied that might be limiting the display to just Q1.
Verify that your X-axis is set to show all quarters, not just a subset.
If these don’t resolve the issue, feel free to share more details or screenshots, and I’d be happy to assist further!
Best regards,
Team KSR
Thank you, DateMaster concept is very nice. It saves time in real time scenarios.
Thanks..Date Master is used in all Projects
Awesome 👌
Thank you! Cheers! Please subscribe our channel, it will motives to do more videos
Thanks sir
So nice of you
sir in the line chart for me why it is showing only for qtr 2 and hence showing straight line?(35.57)
and also when iam pasting the date and avg of total revenue table in from page 3 to page 1 its not showing the complete list i mean scrolling is not happening
Sir, how could I join in ur institute.. powerbi downloadpage is not opening. Pls let me know the process how can I join and fee details???
Hi Sir, Thank you for your interest, Please reach us on +91 9916961234
could you give the link for this version power BI bro and also could you tell is that cracked version
Sir please make a video on star schema, and snowflake schema
Sure. Thanks for suggestions. We will upload asap
I followed same steps for QoQ growth percentage, I eve got the same results in table. Bu as soon as I plot in line chart, it is giving sum total of each year's quarter in chart (eg: for 1st qtr of all year the sum is 30635916.50) So it is showing this value in chart.Also it is adding up the percentage and showing infinity in chart... where did I make mistake...?
I am facing the same issue if u resolved it can uh help me wid that plzz
@@sonuchourasia2865any one find the answer
Select the year 2015. You will get same line chart then
Literally waiting for part 3 … thanks 😊
You're welcome 😊
sir excellent superb sir realally i enjoy the class verry verrryyyyyyyy tq sir good thoughts for all students .....i get more knowedge only for u tq ...share the one more project sir .....all members gain more information in real time project whats happend in real time
Thank u so much.. We will definitely upload more videos
Hi sir, the video is really great. I just had one doubt.
To identify the top 5 employees based on the gross profit using cards, I did everything as shown in the video. However once the filter is applied the card is going blank. Can you please help me with this?
Thanks in advance
There are a couple of reasons why your card might be showing blank after filtering for the top 5 employees based on gross profit:
Empty Ranking Column:
In the video, it's likely they created a calculated column to rank the employees based on gross profit. Ensure you've created a similar ranking column in your Power BI.
This column can be a simple formula like RANKX(ALL(YourTable), [Gross Profit], DESC, DENSE).
Use the correct table name and replace [Gross Profit] with your actual gross profit column name.
Filter Context:
Power BI filters can sometimes interact unexpectedly. When you apply a filter to see the top 5 employees, other filters might be unintentionally affecting the results.
Try creating a separate page or visual specifically for the top 5 employees. This can help isolate the context and ensure the card displays the correct value.
Data Aggregation:
Make sure your card visual is configured to show the correct aggregation of the top 5 ranking. It should likely be set to "Top" or "Max" to display the highest gross profit among the top 5 employees.
Here's a breakdown of troubleshooting steps:
1. Check Ranking Column:
Go to your table and ensure the ranking column exists and has values for all employees.
2. Isolate the Top 5:
Create a new page or visual.
In the Filters pane, apply the filter for "Top N by [Ranking Column] = 5".
This will ensure only the top 5 ranked employees are considered.
Now add your card for displaying the top gross profit. It should show the correct value.
3. Verify Card Aggregation:
Click on the card visualization.
Go to the formatting options for the card.
Under "Value", ensure the aggregation is set to "Top" or "Max" to display the highest gross profit.
Additional Tips:
Double-check the data types of your columns. Inconsistent data types can lead to unexpected results.
Use the "Preview" feature in Power BI to see how filters and calculations will affect your visuals before applying them.
If you're still facing issues, consider sharing a screenshot of your Power BI setup (without sensitive data) for further assistance.
By following these steps and checking your configuration, you should be able to resolve the blank card issue and display the top gross profit for the top 5 employees.
Sir, how could I join in ur institute.. powerbi downloadpage is not opening. Pls let me know the process how can I join and fee details???
Hi Sir, Thank you for your interest, Please reach us on +91 9916961234
very very nice explanation please make these type of videos waiting for next videos
Thank you, I will, Please subscribe our channel.
Hi Sir, i am able to get the total data from Github except sales tables, how i will get sales table date, please help me
let me check and update, Thank you for notifying
Hi Sir,, at 31:03 for total revenue I am getting error its not being displayed I used don't summarize also but the its not getting displayed can you plz help to provide the solution for this/.
Pls give more context on ur issue.. Else pls mail us support@datavizon.com
This is Amazing brother! Learned a lot today. Fan of you :)
good explanation bro..
🤝
thank you so much for bring this kind of end to end projects play list do share this of content
you are welcome, sure will make more video like this
Love you brother...specially sharing the BRD/FRD
Thanks a ton
Did you completed this project?? I need help as one problem occuring.
Hello Sir,
First of all, thank you for this wonderful Power bi series but I have a couple of questions that are why you have used different shades of blue in the pie chart instead of RGB colours @16:47, is it reflect some sort of professionalism, why you have created tot rev measure when you total revenue column to use in calculate function @30:43 and also why you have to change the background colour of date field in last visual, can be left it uncoloured also @42:55?
Thanks for the message. Report should be always with limited colors. Shades gives you good readability and neatness. Measures are generic functions, which can be used for other visuals. Its always good practice to write measures for key numbers. Background was optional. we have kept for good design.
Bro i have pratied today in the final output in the visuals i dint get the same amount like sum of sales and total gross profit and units ..
In this vedio from where we Datemaster it not showed in previous any video
We didn't get you, 👉Please ping on WhatsApp wa.me/919916961234
Hi,
just wanted to know when i drag any calculated Columns it renames the columns as Sum of that value. for eg while dragging total revenue for waterfall chart in Y axis it renamed it to SUM of total revenue, but for you its not changing, it is coming as it is. can you please help me out with this. i don't want the column name to be renamed while dragging.to some aggregate functions.
u need to adjust default calculation
@@KSRDatavizonin facing this same issue, I'm not able to get the same values as you
Even I'm facing the same issue. The values for Total Revenue based on quarter in the table chart are different from what you are getting. Additionally, if I follow the remaining steps , I am getting the QoQ growth in negative percentage.
Kindly help
Very nice video... please post some more end to end projects 😊
Thank you, I will, very soon we are going to provide an end to end bank project
Hello Sir, first of all thank you for amazing project and work.
I have a doubt. While making line graph, I am unable to get normal revenue, somehow its getting adding up and I don't know how to get the data as we got into the table which you showed in sheet 2. please help, sir
Hey parth I'm having the same problem. Did you get any solution to it ?? please help me : )
@@laxmannegi8886 hey man , yes I did resolve it . While making graphs sir has chosen a particular year hence it looks different. If you choose some year from drop down list then it will also come for you
@@ParthPandey-vl3wj can you plzz help me to resolve this issue
@@ParthPandey-vl3wj when i m dragging total revenue to the table it is showing the total revenue same in every cell,i m not getting quater wise revenue
Thank you for your feedback, will make some more sessions with full details , if need any further support please call us
Dashboard is just excellent. ThanQ
Thank you so much
Wow.... sir its just amazing how you r making very affirmations and through deeply visualization into this project...
Thank you for your kind words! It's always encouraging to hear that my efforts are appreciated.
Please subscribe our channel, it helps us to motivate to make more videos.
yaar ye sorting nahi ho rha hai mere es me MONTH ORDER wala dax bn he nahi rha hai koi to batao plz
I understand your frustration. Have you tried checking the data types of the columns you are trying to sort?
Hi, In line chart TotalRevenue and QoQ growth by Qtr , i am unable to draw the same graph which shown in this video. In X-axis taken Qtr and Y-axis Total revenue, in this case graph should show sum of all years qtr revenue, how it shows without showing year value. I am getting sum of all.
Hi Balamurugan, 👉 drop a message on our WhatsApp wa.me/919916961234
HI...am unable to find out more visuals...it is asking for organisational mail ID. how can we overcome that and download scroller visual? Please help me out
yes you need org account for this
Wow,.. amazing.. so detailed video. not like other channels who just try to covers as much as in less time.. Thanks a lot for the series.
That's high praise! I'm glad you appreciated the depth and detail in the video. It's important to me that viewers get a thorough understanding of the topic.
Thank you for watching the series. If you have any other questions or would like more information on this topic, please feel free to ask.
I have one query, Here you used total rev & previous quarter ( calendar master (date) ) for calculating QOQ Growth
Instead of that, can we use current - previous?
Yes or no??
current - previous will not given you growth in %
hi , i am practicing with this data whenever im using category data special is showing but general is not showing for general it showing blank i checked the relation every thing but it showing blank for General can you please suggest me what to do
its difficult to understand your question mam. can you please drop a email with snapshot please - santosh_j@ksrconsultantservices.com
Same issue
Did you solved this problem??? If yes than help me to get out of this
@@KSRDatavizon same issue
one of the best video for beginners
Glad you think so!
Sir, would like to guide me I'm stuck at line chart, i couldn't able to see' Value' in Build Visual Section.
please send email to our team.. our team can help you.. support@datavizon.com
Sir, Am getting an error in date format. it gives the message like "we couldn't parse the input provided as a Date value. In sales sheet. Pls guide me how to fix it.
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Please download from here
This is a great work brother! Thank you so much and be blessed.
You are very welcome
Hi ,Its great to learn from you and Can you please make a project on ticketing system database
Thanks for the idea! will plan shortly. please subscribe our channel for regular updates
❤ TQ 🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉🎉
Welcome 😊, Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot
Hi Sir, i am able to get the total data from Github except sales tables, how i will get sales table date, please help me
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
please download datasets from here
Nice Tutorial Thank you Sir ❤️
Most welcome
How many of here complete this project with same data
Hey did you completed this project? If yes than I need help as in category three options available blank , general, special
all the best guys, hope you are able to finish the project
all the best guys, hope you are able to finish the project
Hi sir , Thank you very much for uploading project vedios. The way u are giving explanation is excellent. Once again Thank u sir
You are most welcome, please do share in your network and visit our website. www.datavizon.com/s/store/courses/description/KSRPowertoolJune2022?TH-cam&Video&Endtoendproject
Great Work👏🏼👏🏼👏🏼
Thank you 🙌
Learned a lot from this series. Highly appreciated and thanks a lot..
I have a one question. Why did you create a measure called 'Tot profit'(at @37:43)? Already there is an existing column called "Gross Profit". So did u create an extra measure? cant we use the "Gross Profit" Column to create a 'previous month profit'(@38:23) measure instead of 'Tot profit' Measure?
the purpose of creating measure is to make sure, it can be re-usable for other functionality
Sort by month column already is there y did u take one more colum month no sir
Yes you could have used.. thanks for the catch
Could you please create a report on status of percentage by department wise using stacked bar chart
Pie Chart is better for this example
think you so much
welcome Sir
top 5 sales rep is somehow showing wrong names in slicer.@KSR Datavizon
top 5 will multiple row will be sorted names.
can you please give functional requirment files please...
All files is attached in GitHub and shared in description. Please refer and download
Sir, video is really good. Can I get requirement document &pbix file for practice
Yes, sure. All files is attached in GitHub and shared in description. Please refer and download
Table lo cumulative not cmg in total revanue. It's show total quarter revenue only
Have you created datamaster table? please use same formula as shown in video
I follow same steps
Excellent commanding on the subject and nice explosion even a novice like me can understand easily... thank you a lot bro...
Thanks for your comments
its very nice and easily understanding sir
when will be the publishing the report video
today we will publish!!!
@@KSRDatavizon please publish it, waiting for your video
Sir one of my friend passed out in 2013 now he wants enter it feild is there any problem
Hi Sir, Thank you for your interest, Please reach us on +91 9916961234
Please provide this data for practice
drive.google.com/drive/folders/1osPrmC-Nb19w1XAPDMkfUIVRR2iER4ZB?usp=sharing
Thank you for your effort, Your awesome teacher This helps so much
Did you completed this project?
Glad to hear that! Thanks
What are prerequisites to learn power bi
Just a Degree
Scroller feature is so fascinating
Hope you liked it.. we use in most of projects
Sir when i am creating donut chart for total revenue by category in that General category is not showing. instead of its showing (Blank)
could be a error in any calculations
Same issue han bhai
If you solved this problem than please also help me to find
@@KSRDatavizon same problem please help in this
Kisi ne solve Kiya iss problem ko
Hi sir,
As the requirement 3.7 Breakdown analysis, what if I choose month or Country will that impact waterfall visual, if yes Does it met the requirement?
Please answer..............
Sir Please provide an answer for this or any one who see the question can answer
Waterfall chart is best suited for breakdown analysis. As per requirement, they have asked for product breakdown analysis. So we have implemented. (we can use month or country as well)
Can you please attach the FRD .
All files is attached in GitHub and shared in description. Please refer and download
What is the power bi tester work?
Will validate all fonts, filter checks, requirement fulfillment check, smoke testing, data validation
Really helpful 👌
Very Excellent Work.
Thank you, Please subscribe our channel for regular updates, its motivate us
Please upload 4 th part
All videos in playlist is uploaded. Please check
Excellent work.
Thank you, Please subscribe our channel for regular updates, its motivate us
hi sir, add BRD document
All files are uploaded to GitHub provided in description. Please refer and download.
Thanks you sir, please do some complex project on power BI
Some more dax functions
Great series . Thank you
Glad you like them! Please do share :)
Excellent
Thank you so much 😀
Superb sir ,really I like your explanation style, THANK YOU so much sir keep giving us real time projects.....🥰
Welcome !!!
Do u provide any placement assistant
Yes we do, please call to +91 9916961234
4th part when can you upload i am eagerly waiting
we will upload today!!
please share data with me
All files are uploaded to GitHub provided in description. Please refer and download.
Line chart is straight no up down variation
its as per data sir
I too facing the same issue is it resolved?