Could you please help me solving the below query: I have pharma dataset with these fields: Company, Drugs, Medicine, Year, Sales. I have just 2 visuals: 1. Bar Chart: Displays medicines vs sales. 2. Table: Displays all the column/rows from the pharma table. Functionality: When a user clicks on a medicine in the bar chart, the table should automatically update to show all alternate medicines that belong to the same drug but exclude the selected medicine.
Months are in text and by default power bi doesn't recognize text and sort it chronologically. To resolve this create a column with month number and then sort it using month number.
Hi, I have one of my connection who is working in PWC and I also want to join PWC, I have better knowledge of advanced Excel and power BI but I didn't work on SQL but I know basic SQL query. Can I get job in PWC this 2 skills.
![The Complete Data Analyst Roadmap [2024]](http://i.ytimg.com/vi/YRJbhFLLPyE/mqdefault.jpg)
Dataset Link- docs.google.com/spreadsheets/d/1IalLi_53RTGUc6wCWcT-zUwbKj1I-TH9/edit?usp=sharing&ouid=102679157628567582944&rtpof=true&sd=true
Even the chart you selected is stacked column chart .
As per the question it should be bar chart not column chart .
And thanks for the question.
You should make more of this videos ❤❤
Could you please help me solving the below query:
I have pharma dataset with these fields: Company, Drugs, Medicine, Year, Sales. I have just 2 visuals: 1. Bar Chart: Displays medicines vs sales. 2. Table: Displays all the column/rows from the pharma table. Functionality: When a user clicks on a medicine in the bar chart, the table should automatically update to show all alternate medicines that belong to the same drug but exclude the selected medicine.
maybe ALLEXCEPT should work here ? which would keep filter on for column medicine
Why 18.37%? it should be 59.38%. Can you clarify?
Nice questions and a very good explanation
Glad you found it helpful.
in first question divide function first used inbuilt dax and in dinominator used measure please expalin it sir
You have calculated cost top 5 sum based on revenue top 5 .. can you check that and change
I liked your way of explanation, bro..
Glad you liked it!
Wow bhaiya 😇
Sir can share with us all interview questions answers in data analytics??
how to apply for startups
how to arrange month axis in right order ? why it showing wrong order ?
Months are in text and by default power bi doesn't recognize text and sort it chronologically. To resolve this create a column with month number and then sort it using month number.
You have to go to the table view and sort the month column by Product ID
there is a sort by option, just select it and choose sort by product id or which ever column you created to represent the month names.
@@DataTuner Thnk u
@@nandana_v613 Thnk u
Hi, I have one of my connection who is working in PWC and I also want to join PWC, I have better knowledge of advanced Excel and power BI but I didn't work on SQL but I know basic SQL query. Can I get job in PWC this 2 skills.
Practice interview problems on SQL so that you can learn SQL quickly
Hey..how I get job in power bi domain..I am searching in Bangalore
Same please tell us
Why are you calling column chart a bar chart
Column chart is a type of bar chart , as we have vertical bars in column chart that's why we say it columns
@TheAnalyticsEngine ok
@TheAnalyticsEngine but the chart selected over here already have name so we can not say it bar chart .you can check it in BI
Made vedio after long time 😡