Forum Discussion
Change column data type
Thank you for the prompt response and sample solution prateekraina!
If you try running a report and change the table to a bar graph as the visual, whether you choose check or unchecked as the status, you get a "count of checked", although the count varies, it's still shown as count of checked.
the second png, are the questions separated indivually, so for each question, if I click the "checked", I get an actual count of responses to for that question, but I want to show a graph that compares count of ALL the responses at the same time in a bar, or pie or circle graph. Hope I'm explaining myself correctly.
Hi Anonymous,
Would it be possible for you to draw what result you expect in Excel or Paint. I am a bit confused.
Is it something like below?
Prateek Raina
Hi and thanks again. I’ll do as soon as I have a chance
Hi prateekraina,
see attached files, hopefull will explain a bit more.
I also created a pbix sample file. How can I share that with you?
As I've mentioned before, instead of separate columns with the same question/different choices, I'd like 1 column with the choices to pick from and be quantified, if you see in the Excel file, if you try to create a Pivot Table/Chart, all you get quantified are the checked/unchecked, not the actual choices.
Hi Anonymous
A simple file will be really appreciated.
You could upload the file by choosing files to the attachments below, or upload file to OneDrive, and then share me with the link.
Best Regards
Maggie
Hi Maggie,
thank you so much for your reply and wanting to help, but there's no option to upload a file that I can see here. Please advice
