@@jessiki5711 This could happen depending on the Excel version. You can still create Pivot Tables from there anyway. However, with few additional steps From there.... Select create connect and check; add to data model. .. wait for it to load Now proceed as follows Insert>Pivot Tables>External connect>Select Unpivoted or data table you loaded>>add>Ok Then create your pivot table

@@joyhardy2467 Do you get the reduced total after you filtered the Blank label in the rows of the pivot table? If you don't have Blank label (or if had not filtered it out at all) but the total is still less than expected: Do this 1. Go back to power query 2. Before you Unpivot; 3. And an index column (starting from 1....). Let's name it Dummy 4. When selecting columns to Unpivot, add the Dummy column too 5. Then Unpivot . However, this will result in many values when you do crostab. 6. So you need to filter out the dummy label in the rows of your pivot table. Alternative to the long list of values in the dummy column: 1. Add a conditional column: Name Dummy column 2. Condition: If ID is not equal to 0 return 1 else return 0 3. That way will will only have 0 or 1 in your dummy column. Let me know if this helps If this doesn't help, you can send me an email to connect and understand the issue better

Adding to my previous question. This situation results in the grand total being less than the total number of survey respondents.

@@dajanabushpepa4389 That's another way to o handle it. I have used that approach too in a separate video. Thanks for the reminder

Thanks for this. Missed that. The column label should have been Bottom-2-box too as the tittle. Values are Bottom-2-box, anyway.

@@andrewtirtawijaya5627 Check this video From 3 minutes on kzbin.info/www/bejne/jYmYmX-Fm6hkiJIsi=mYS4jfkmDtUL3NKb

@@andrewtirtawijaya5627 Another option is to Unpivot each of them in the same table as I have done here for comma separated. But be careful as with this option for large sample sizes and with many columns as I have mentioned in the video

@@andrewtirtawijaya5627 If you still support, you can send me an email [email protected] Note that a small consultation fee is applied for an hour session. All the best

Glad it was helpful!

Glad it was helpful!

@@jaunitaekuehettah1254 Hi Jaunita, Thanks for reaching out. Send me an email below with details of your requests. Please add timeline. Connect with me if you need support on the following services Email: [email protected] Book appointment here 👉 calendar.app.google/MMasAbZPDuwCCux76 1. Survey questionnaire design 2. Online survey scripting 3. Survey data Analysis 4. Research report writing 5. Data analysis in Excel 6. Survey Dashboard in Excel 7. Survey Dashboard in Power Bi The scope of my services includes but not limited to the areas of Market Research, Customer Experience Research, Product Research, User Experience Research, Employee Engagement Surveys, NPS, CSAT & Voice of the customer, Monitoring & Evaluation, etc.

@@Data4Transformation In multiple response questions, total number of responses will mostly be more than the total number of respondents since each respondent could select more than one response item. So sum of percentages (of the number of respondents) will be more than 100% Others however, often mistakenly divide by the total number of responses and get 100% which they go further to wrongly interpret the results. For example saying 20% of the respondents.... when the percentage is not based on the number of respondents. So, the earlier is the correct way to treat multiple response questions.

@Data4Transformation Find the explanation in this video. You may want to check it out kzbin.info/www/bejne/g6PPd6OZjLWpjMU

@boblynnamanyire2274 Check this recent video on this: kzbin.info/www/bejne/a4OyoJaNocd6j9k

@@boblynnamanyire2274 Happy to know this is helpful. Thanks for the feedback

@@lawrencekazibwe9751 Glad this helped. Thanks for the feedback

​@@Natnatnatnatnatnatnat Thank you for the encouragement 🙏

@@asifkhan-k3m3cGlade this helps

@@asifkhan-k3m3c Glade this helps.👍 All the best with your project

Hi Doreen Probably, at the Home tabe in Power Query Editor, you did't select the "close and load" option. The dialog box that appear for you option to select how you what you want to do with the data from power query edit will only appear if you did select "close and load" option when loading your data from the power query editor. Could you reload the data to power query editor and proceed accordingly with the "Close and load" option. Should you need further assitance you can reach out to me via email to understand the issue and how I can assist. [email protected]

Yes i did click the "close and load" ... but it didn't show the "pivot table report"

Glad it was helpful!

Can you check if you did have a column named ID in your survey data? The ID column can be any column that column with entries that uniquely identifies each respondent or data entry in your data like telephone number, student Id number, survey submission Id, etc. You can use any similar column in your data that uniquely identifies each respondent. If not captured, you can add this manually in excel (insert column in your data table and number each row from 1, 2, ...n) or in power query using the Index feature from 1,... (Add column>>Index column....)

Yes. However, here the standard Chi-Square test is not appropriate since there is within group dependency as respondents had the option to select more than one item in each of the multiple response questions. Marginal Chi-Square test is recommended in this case.

Yes, you can apply slicers to the analysis table. Click anywhere in the table: Under the Pivotable Analyze table at the top.... Select Insert Slicer... Select the Unpivoted Data table.... Check the respective variable (like age group, gender, region, etc) for your Slicer and Okay. If you have other pivot tables created from your main Data Table in the model... Insert the Slicer from that... Then establish relationship or connect that table to the Unpivoted Data Table using the ID column.

Could you check if the new data is showing in your source data table in power Bi? before the duplicated table. If it is showing, you may consider unpivoting directly in that table. Maybe the duplicated table is not calling the new data from the updated source data table

Entries in the ID column are unique identifiers for each respondent in your survey. Could be autogenerated by the survey platform, contact numbers of respondents, student/staff Id, etc. If you do not already have such a column in your data, you can add a custom column in your data (before Loading to power query): 1. Insert a column in your data table. Usually should be first or second column. Ensure that column is your table with features of a table. 2. Number you respondents starting from 1, 2 , 3.....n. If you already generated pivot table. You can Refresh All to get the Id in your data model. Then you can use the column in your analysis as in video Alternatively, use the custom column Id feature in power query to do that; ideally before unpivoting

Hi Juliana You should see that once you load your data to power query. Not sure. But should be available in Excel 2016 and later

Thanks for the feedback. Noted. I will add this up in my upcoming videos

Thanks for your feedback. Happy to know this helps.

Glade to hear you found it helpful.

He sounds Ghanian

Agreed, I mentioned it in the video. You can first split into columns, then unpivot. But that will also still give you multiple rows. That is why we count by Distinct. Unfortunately, I am yet to find any better & efficient way to go about this without getting multiple rows. For some reason, the multiple rows have nearly no impact on analysis as far as you count by Distinct. I am curious to know why stacking the data doesn't work for you.

​@@MSurveyPoint I have a column 'Total Sales" - 10000, Country = "India,China, Japan". After creating multiple rows the sum(total Sales) is giving me 10000* 3 = 30000. Earlier it was just giving 10000 This is just an examoke

@@Hussainiat_news__Channel I understand your concern. But since you are adding to data model, the data will be stored in power query. Power query can handle as many rows there are unlike excel spreadsheet which has 1m rows limitation. Only the speed of the data processing may be affected subject to your PC's capability. Like in the video, I got 50k+ rows and still proceeded speedly. Check this video I explained this for Excel and possible precautions. kzbin.info/www/bejne/jZvQhYF7ost9aNU

@@MSurveyPoint how do I get the sum of column for distinct ID? In a measure?

Since the value column is numeric and you want total sales for each country: You will use Show values as Average. to take care of the multiple rows.

Thanks for the feedback. Glad to hear that helped. Subscribe to stay updated

Thanks for the feedback. Happy to know this helped. There are always more than one way to represent data, depending on the story you want to communicate with the data. And the format of the final output of your analysis/report: word, PPT, infographic, dashboard, etc. For percentages like we have in the video, and which part of the scale is most important to you; other considerations are 1. Table: well formated, sorted or key numbers highlighted. etc. as 2. Conditional formatting, highlighting high & low scoring. 3. Single column bar chart , focusing on the top 2 scores( Etc.

Hi Godfred From 8:10 onwards Can you check if you selected "Close and Load to data model" from the Power Query Editor? Check also if the "add to model was checked" in the add to data model dialog box.

@@MSurveyPoint Yhyh...I did but it doesnt allow me to check the add this data to data model

The ✅ is enabled depending on the option you select at the top; pivot chart, connection only, etc. It will be automatically selected and grey out for some options. Can you check that. Also, are you able to proceed to generate a pivot table or chart and do your analysis? Lastly, you may consider starting over and following steps in the video closely

Hi Tinah Happy to hear this helped. Subscribe to stay updated

Thanks for letting me know. On the surface, you can generate a chart from the pivot table, move to your dashboard and link to other charts via a slicers. You can book my calendar for tomorrow to align on what you want to achieve and how I can support.

@@MSurveyPoint I tried to do that but the slicer was not responding. Let me send you an email

@@norahmutale4391 Alright. Sounds good

Hi Nora. Glade you find it helpful. This could be what you are looking for. kzbin.info/www/bejne/hXXXiKmJgLqGf9E Do subscribe to support my channel

Glad you found it helpful

You can apply the same approach. But here, One way is to: >>Select the set of statements for topic 1 and unpivot like in this video. You can name the attribute column as Topic 1_statements. >>In the same table, select the set of statements for topic 2 and do the same >>Repeat for the rest of the topics you have. Caution: Your model could be come bigger with this approach (number of rows could run into millions because of the several unpivoting) Alternatively, >Duplicate your data for each of the topics >>Then apply the previous steps for each separately. >>You may name each table for example _Topic 1_Company culture >>Afterwards you the load all the tables into your data model. And proceed with your visualization like in the video. I hope this helps. Do remember to subscribe to support my channel

@@MSurveyPoint thank you very much, finnaly i have solution now

@@arthautami9999 Glade this helped

Thanks for sharing your feedback Glade to hear this helps.

Thank you for the feedback. Happy to know this helps. Kindly support my channel by sharing with your team. Thank you

Thanks for the feedback. I am glad you found it helpful. I will continue to share more relevant videos. Best regards

You're welcome!

This is inspiring to hear. Thank you for the feedback