Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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"