Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KHouseknecht
New Member

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

  • PPE
  • Materials
  • Position

This ^, in smartsheet becomes,

 

StevenSafety 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?

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.