Forum Discussion
Syndicate_Admin
Administrator
AdministratorHow 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...
Hi,
In the Power Query Editor, right click on the first column and select "Unpivot Other Columns". Now create your desired visuals.
Syndicate_AdminAdministrator
AdministratorHello! Thank you for your help.
I have a billing table with columns by sector and rows by month.
I can add a filter by date.. but not by sector because it is the name of the column. it is not table data.
Ashish_Excel
Solution Supplier
Solution SupplierHi,
In the Power Query Editor, right click on the first column and select "Unpivot Other Columns". Now create your desired visuals.