Forum Discussion
Smartsheet Multiple selections converting to unique text strings in BI
I'm having trouble with the way smartsheet data is converting to powerBI. I'm trying to set up a line graph to track safety incidents across our sites, and each incident can have multiple types listed. In smartsheet its a multiple value dropdown, but when that gets converted to powerBI it becomes a unique string of text instead of the multiple selection values. For example
| Steven | Safety Incident |
|
This ^, in smartsheet becomes,
| Steven | Safety Incident | PPE, Materials, Position |
In power BI. So my Line graph instead of having 30 "PPE" and 15 "Materials" etc, has 4 "PPE, Materials, Chemicals" and 2 "Chemicals, tools" and 5 "PPE, Chemicals", etc.
Is there a way to get Power BI to recognize the individual selections as a multiple dropdown and not unique strings of text? Or some workaround to make that happen?
HI KHouseknecht,
I don't think power bi can directly recognize these dropdown list values. They should be recognized the common text values. Perhaps you need to operate on these field values based on delimiter to spilt them to column or row to help filter effects accurate work on these fields.
Regards,
Xiaoxin ShengHi,
In the Query Editor, you may split the data into rows using comma as a delimiter.
2 Replies
HI KHouseknecht,
I don't think power bi can directly recognize these dropdown list values. They should be recognized the common text values. Perhaps you need to operate on these field values based on delimiter to spilt them to column or row to help filter effects accurate work on these fields.
Regards,
Xiaoxin ShengHi,
In the Query Editor, you may split the data into rows using comma as a delimiter.