Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

How to create slicer for table columns

Hello

 

I have the following table loaded in Power Query which shows the attendance of people starting from 1 January 2022 until 31 December 2022. In Power BI, i would like to have a slicer with selectable names or a way to allow the report reader to display the attendance by name. I'm not sure how to do this - should an extra column be added in Power Query or is there some DAX to make this work? Any help is much appreciated!!

 

DateLizuiLaufenburgTegalpapakAr RabiyahBellegardeGangarampur
01/01/2022111111
02/01/2022101111
03/01/2022101111
04/01/2022101111
05/01/2022101111
06/01/2022101111
07/01/2022101111
08/01/2022101111
09/01/2022101111
10/01/2022101111
11/01/2022001111
12/01/2022001111
13/01/2022001111
14/01/2022001111
15/01/2022001111
16/01/2022001111
17/01/2022001111
18/01/2022001111
19/01/2022001111
20/01/2022001111
21/01/2022001111
22/01/2022100111
23/01/2022100111
24/01/2022100111
25/01/2022100111
26/01/2022100111
27/01/2022100111
28/01/2022100111
1 ACCEPTED SOLUTION
Jos_Woolley
Solution Sage
Solution Sage

Hi,

So you've currently set it up so that each column is for a different person? Would strongly suggest unpivoting in Power Query, e.g.:

let
    Source = Excel.CurrentWorkbook(){[Name="MyTable"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Date"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

which will lead to a more flexible and amenable dataset.

Regards

 

View solution in original post

1 REPLY 1
Jos_Woolley
Solution Sage
Solution Sage

Hi,

So you've currently set it up so that each column is for a different person? Would strongly suggest unpivoting in Power Query, e.g.:

let
    Source = Excel.CurrentWorkbook(){[Name="MyTable"]}[Content],
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"Date"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"

which will lead to a more flexible and amenable dataset.

Regards

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors