Forum Discussion
Create a slicer with Column Headers
Is it possible to create a slicer with column headers? I would Like to create a drop down slicer that only shows header names and not values ( Line Rate, Accessorial Rate, Hourly Rate, Non- Hou...
Anonymous You can use power query to create this - please replace TheTable below to the name of your table.
On the Advanced editor, create a blank query and use this code:
let Source = Table.ColumnNames(TheTable as table) as list, #"Converted to Table" = Table.FromList(Source, null, {"TheHeaders"}) in #"Converted to Table"
sanimesa
Post Prodigy
Post ProdigyAnonymous You can use power query to create this - please replace TheTable below to the name of your table.
On the Advanced editor, create a blank query and use this code:
let
Source = Table.ColumnNames(TheTable as table) as list,
#"Converted to Table" = Table.FromList(Source, null, {"TheHeaders"})
in
#"Converted to Table"
