Forum Discussion
Solved
Data modeling question
I'm hoping someone can at least point me in the right direction to do more research. I have a field in my data set that technically a single line text, but has multiple values separated by commas. Ho...
Sean I think I did this right. I don't know how to do it in PBI Desktop, so I just created a table in Excel. I didn't see an attach file option, so I just pasted it here.
| ID | ProviderQuoted |
| 1 | Cox, CenturyLink, Level3 |
| 2 | Cox |
| 3 | AT&T, Level3 |
| 4 | Wow!, CenturyLink |
| 5 | inContact, AT&T |
Sean THANK YOU SO MUCH. This was so easy to follow along, and worked perfect.
What if I need the count to add up all the time?
Lets say there are 400 respondents, but for a question, only 300 have answered. If I show the result some people would start arguing that there is something wrong with the data since it is missing 100 respondents.I would say, they are not missing they did not answer the question. But if I wants it to add up to 400, showing the 100 respondents as 'Did not respond' in the legend. How to do that?
