Smartsheet Multiple selections converting to unique text strings in BI

[KHouseknecht]

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

PPE Materials Position

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?

[Anonymous · Accepted solution]

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 Sheng

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, you may split the data into rows using comma as a delimiter.

[Anonymous · Accepted solution]

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 Sheng