Transferring a dropdown multi-select column into PowerBI

Tori Heath
Tori Heath ✭✭✭✭
edited 06/14/22 in Add Ons and Integrations

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.