Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Bar Chart not Representing Full Source Data Set

Hi All,   I'm a very new user to Power BI and just getting to grips with it recently. I have completed a survey through work with some customers and wish to use Power BI to analyse the results. One...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    If you want to show the count of answers, you can try split columns and unpivot columns.

    My Sample:

    Duplicate Data column as Data-Copy, and split column by ";".

    Select three new columns and use unpivot column.

    Finally remove Attribute column and build your bar chart.

    If this reply still couldn't help you solve your problem, please provide me with your sample by Onedrive for Business. You can show me a screenshot of the result you want as well.

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous you provided great details but it will be easier if you put some sample data/screenshots and tell what is not working and what you are expecting.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi there,

     

    Below is a snip of some of the data I'd like to plot.

     

     

    As you can see, the breakdown of answers is as per below:

     

    Email to NTQ Engineer - 5

    IM to NTQ Engineer - 2

    Meetings & Review - 1

    JIRA/Confluence Issue Tracker - 1

    Call - 1

     

    However, when I try to plot this data on a bar chart as is, effectively there are 4 rows with unique sets of data in them. I have tried splitting the column into as many columns as is needed to accomodate multiple answers and then plotted all of these resulting columns with single entries onto a stacked bar chart.

     

    Below is an example of this using a different question from the survey but having the same scenario. Surveyees input up to 4 answers to the question so I've split the answer column into 4 distinct columns. I then plotted all 4 columns as the Values in the bar chart but the accumulated totals in the raw data table don't match the actual number of entries when I manually add up the entries of a certain answer across the 4 columns. For example, the first column according to the bar chart shows a total of 40 but the raw data adds up to only 31 entries with 24 in column 1, 7 in column 2 and none in column 3 and 4. I'm very confused by the whole thing

     

    (Apologies I had to censor the text as it is confidential.)