Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
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.