Transferring a dropdown multi-select column into PowerBI

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.

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.