Forum Discussion
Data modeling question
Can you post sample data of this column and what your Unique Row Identifier looks like?
Caitlin_KnoxBasically this is how you can do this...
If something is unclear just ask! :smileyhappy:
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?
