Forum Discussion

Reh's avatar
Reh
Frequent Visitor
7 years ago
Solved

Group multiple columns into single filter

Hi, Please see below. I have 3 columns with name of companies that can repeat row to row. How do I create a table with column 1 and column 2 info that can be filtered by by name of the companies from...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Reh 

     

    You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Reh 

 

You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.

Regards,

Cherie