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...
Using the wonderful Split Columns option in the Query Editor. It will create new columns which you can then rename.
So, that would create 5 columns..Which do I use when creating the slicer? And how would thatrelate back to the rows?
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
