Transferring a dropdown multi-select column into PowerBI

Tori Heath · 10/05/20

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 · 10/05/20

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 · 06/01/22

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

hdavey · 09/13/22

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 · 01/08/24

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

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

Transferring a dropdown multi-select column into PowerBI

Answers

Categories