Forum Discussion
WinterMist
Impactful Individual
Impactful IndividualBest Practices Q - Handling Text ID Fields With Comma Delimited Values
Hello Community, I'm looking for Best Practice (or otherwise) guidance on how to handle Power BI reporting for this specific undesirable source data situation. PROBLEM: Usually in source data...
Hi WinterMist
To split the [Rejection Reason ID] column, in Power Query, do the following:
1. Select 'Fact Rejections'[Rejection Reason ID] and hit "Split Column".
2. Use "comma" as the delimiter.
3. Open "Advanced Options" and set "Split into" to "Rows"
4. Close & ApplyI hope this helps.
gmsamborn
Super User
Super UserHi WinterMist
To split the [Rejection Reason ID] column, in Power Query, do the following:
1. Select 'Fact Rejections'[Rejection Reason ID] and hit "Split Column".
2. Use "comma" as the delimiter.
3. Open "Advanced Options" and set "Split into" to "Rows"
4. Close & Apply
I hope this helps.