Forum Discussion
Change column data type
Hi all, this power BI newbie needs help with a challenging doosy.
I have a data source file with a list of people associated with a question and several choice answers: =choice
However, instead of making the question a column with the choices to chose from, each =choice was made into separate columns with "checked"/"unchecked" as the data type (see partial screen shot), and I imagine that "check" means yes, as =choice to the question.
When trying to creat a columns visual to determine how many individuals are associated with each of the = "choices", all I get is a count of ALL the "checked"/"unchecked" lumped together.
The only way I've been able to get indivicual counts has been creating single Card visual for each of the =choices and clicking and selecting the "checked" (see sample).
Is there any way I can place all the =choices into a single column of choices? AND associate those choices with the "checked" that people chose in response to the question?
10 Replies
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
