Forum Discussion

Julier's avatar
Julier
Helper III
9 months ago
Solved

column headers as a slicer

Hello, I have my data in power query as below which i have a chart and a table  visual working from this,  i want to be able to slice the table and the chart with a slicer using the column headers, i...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    9 months ago

    Julier 

     

    Download this example PBIX file 

     

    So what you are trying to do is only show the columns of data selected in the slicer?

     

    You can use a Field Parameter for this.

     

    From the Modelling menu -> New Parameter -> Fields and add the Fields (columns)

     

     

    make sure the check box 'Add slicer to this page' is checked and click Create

     

    Create a table and add the parameter you just created, use the slicer to display the columns you want

     

     

     

    Regards

     

    Phil

ralf_anton's avatar
ralf_anton
Resolver I
9 months ago

...ich denke, so herum wäre es Dir vielleicht lieber:

 

Der M-Code hierfür:

let
Quelle = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
OrgTopics = Table.ColumnNames(Quelle),
TopicDown = Table.DemoteHeaders(Quelle),
NewTopics = Table.ColumnNames(TopicDown),
NewNames = List.Zip({NewTopics,OrgTopics}),
RenameColumns = Table.RenameColumns(TopicDown,NewNames)
in
RenameColumns

 

Oder lieber so?

...dann diesen M-Code:

let
Quelle = Excel.CurrentWorkbook(){[Name="Tabelle1"]}[Content],
#"Tiefer gestufte Header" = Table.DemoteHeaders(Quelle),
#"Transponierte Tabelle" = Table.Transpose(#"Tiefer gestufte Header"),
#"Sortierte Zeilen" = Table.Sort(#"Transponierte Tabelle",{{"Column2", Order.Descending}}),
#"Höher gestufte Header" = Table.PromoteHeaders(#"Sortierte Zeilen", [PromoteAllScalars=true]),
#"Umbenannte Spalten" = Table.RenameColumns(#"Höher gestufte Header",{{"Monat", "Attribut"}})
in
#"Umbenannte Spalten"