Forum Discussion

Saloni's avatar
Saloni
Helper I
9 years ago
Solved

Filter

Is it possible to filter data through a row? I have a column containing 60 dates and another 10 columns containing data from different companies. Can I create an area chart/line chart and filter whic...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Saloni,

     

    If I understand you correctly, you may need to use the Unpivot option in Query Editor to unpivot the 10 columns which contains data from different companies to "Company" column and "Data Value" column first, then you should be able to use the "Company" column as filter to get your expected result. Here is an article about unpivot columns for your reference. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Saloni,

 

If I understand you correctly, you may need to use the Unpivot option in Query Editor to unpivot the 10 columns which contains data from different companies to "Company" column and "Data Value" column first, then you should be able to use the "Company" column as filter to get your expected result. Here is an article about unpivot columns for your reference. :smileyhappy:

 

Regards