Forum Discussion
Bar Chart not Representing Full Source Data Set
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.
Super UserAnonymous can you put sample data in a pbix file and share it, will be much easier to work with, just make some fake data.
Thanks. I have generated a sample data set but I don't see an option for me to attach a file to cmy response. I am able to attach photos and videos but no option fore standard files. Maybe it's because my account is new.
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.
Sorry for the delayed response. This looks like it will work. I'll try it with my current data set. Thanks again.