Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago
Solved

How to filter a data by Column and by Row?

Good afternoon Do I need to filter a single piece of data by specifying the column and row? I can't find any simple filter to extract a specific piece of data from a table. Thank you Best re...
  • Ashish_Excel's avatar
    Ashish_Excel
    1 year ago

    Hi,

    In the Power Query Editor, right click on the first column and select "Unpivot Other Columns".  Now create your desired visuals. 

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Syndicate_Admin ,

Please follow the steps provided by Ashish_Excel , to create the desired visuals and test the solution. If it works for you, kindly consider marking the response as ‘Accept as Solution’ so it can help others facing similar issues.
If the issue persists or you need further assistance, feel free to share more details for additional support.

 

Thank you for your quick response rohit1991 .