Forum Discussion

Sherbman's avatar
Sherbman
Frequent Visitor
3 years ago
Solved

Insert a slicer based on multiple columns

So I work at an insurance company and we have an excel sheet of provider name and the different insurance company that they are contracted with.  And the number of columns of insurance companies...
Need Help
  • JoeBarry's avatar
    JoeBarry
    3 years ago

    Hi Sherbman 

     

    Within Power Query, highlight all columns except Provider Name and right click and choose unpiviot columns. 

    This will create two new columns 

    If you need to keep the Providers with No, duplicate the table and call it DIM Providers and then filter the Value column to Yes. In the provider Name column, right click and remove duplicates. Load both tables. Create a One To Many relationship on the Provider Name on both tables.

     

    From the DIm Providers Column, add the Provider Name to a Slicer.

     

    Thanks

    Joe

     

JoeBarry's avatar
JoeBarry
Solution Sage
3 years ago

Hi Sherbman 

 

Within Power Query, highlight all columns except Provider Name and right click and choose unpiviot columns. 

This will create two new columns 

If you need to keep the Providers with No, duplicate the table and call it DIM Providers and then filter the Value column to Yes. In the provider Name column, right click and remove duplicates. Load both tables. Create a One To Many relationship on the Provider Name on both tables.

 

From the DIm Providers Column, add the Provider Name to a Slicer.

 

Thanks

Joe