Forum Discussion
Mederic
Post Patron
3 years agoHiding columns with a slicer in Excel-Power query
Hello everyone,
In the screenshot below, I have a table in which the columns are hidden via a table with a "Yes" or "No" column
However, I would like to get the same result using a slicer
Is this possible in Excel with Power query ?
For information, I actually have about ten columns and more than 1000 rows
Thank you in advance for your help
Regards
| A | B | C | D | E |
| vb | nf | uy | ey | ut |
| yt | sq | sq | tf | gd |
| tf | su | yg | xs | qe |
| gy | ud | jv | sk | op |
| Column Name | Hid |
| A | No |
| B | No |
| C | Yes |
| D | No |
| E | Yes |
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"A", type text}, {"B", type text}, {"C", type text}, {"D", type text}, {"E", type text}}),
#"Removed Other Columns" = Table.SelectColumns(#"Changed Type",Status)
in
#"Removed Other Columns"
let
Source = Excel.CurrentWorkbook(){[Name="Status"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column Name", type text}, {"Hid", type text}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Hid] = "No")),
#"Column Name" = #"Filtered Rows"[Column Name]
in
#"Column Name"
No RepliesBe the first to reply