Can I somehow in Excel or, better, in PowerBi, make a selection with a slice of columns that I need to visualize?

In sql, I can write a query, select col1, col2 from table - can I also select only those columns that I need in Excel or PowerBI in the same way?

For example, from the report I need information for only a few cities.

  • It is possible in VBA. Data in an array, from the array the necessary data is written to another array. Easier (also in macro): copy the sheet, delete the columns in the copy, if necessary, load the cleaned data into the array, delete the temporary sheet. - vikttur
  • Thank you!) So in Power BI is it possible? And through the cutoff buttons will this filtering work? - Maxim Frolov
  • Alas, I do not know. In VBA is possible. - vikttur
  • Split the table into several different tables in the query editor. Be sure to put the connection in PBI. If you need a detailed solution, send an example file. - ERENNEL

0