Transferring a dropdown multi-select column into PowerBI

Tori Heath

Hi Community,

I'm hoping someone might have a suggestion for how to best translate a dropdown multi-select column in Smartsheet into a PowerBI slicer. 

I'd like the PowerBI slicer to mimic the Smartsheet dropdown options, but instead I get a list of every unique combination of all the options. See photo:

Here are the Smartsheet dropdown settings:

Hoping there is a solution out there! Many thanks in advance.

M Underbrink

Easy, but ugly solution, is to parse out the values from the multi-select columns into checkbox columns specifically for the BI integration. you could hide those 'helper' columns after creating them.

• Create a column for each of the 8 options
• Create a column formula for each column =IF(CONTAINS("Monitoring",[Contract Details]@Row), 1, 0), update the "Monitoring" with the proper value for each column.
• Run a new export

brodyleonvantage

YES! I have the same problem. Really hoping to find a solution to this ASAP

hdavey

In the PowerBI query:

• Right click>Reference the table from smartsheet to create a new one
• remove columns other than "ID" and "Contract Detail"
• Split the "Contract Detail" column by delimiter (comma) - select the split to rows option.

In the modeling view

• Add a relationship from the new table to the original table (1 to many)

In the Report view

• Use the "Contract Detail" field from the new table in the slicer

AEForrest

https://community.smartsheet.com/discussion/comment/343363#Comment_343363

Thanks so much! I also had this exact issue and this solution worked perfectly.