Can we use multiple columns as a source of input for a slicer?

[adharia]

Hi, 

I have an employee database which consists information about his department, project name, Location from where he is working, number of hours worked in particular month(January, February, March....). I want to create a slicer for the months section where by just selecting the month, I would come to know how many hours an employee has worked in that month. But the main issue comes when I try to drag the data to "Field" section it allows me to add only one column(i.e. only April or May or June...). Can anyone help me with creating a slicer?  Below is the sample data set. 

I want to create a slicer(Output) like 

[fhill]

The data sample you provided is already in a Pivot or Matrix layout.  If you highlight ONLY your months columns when in Query Editor in Power BI. you can choose 'Unpivot Columns' under the 'Transform' tab.  This will turn you data into something closer to my 2nd screen shot below.

Once you have the data in a Data Detail Level format, you can now easily choose 'Attribute' (or whatever you choose to rename this column after the un-pivot) as a slicer.

Thank You,

FOrrest

(Data in Pivot or Matrix format)

(Data Un-Pivoted in Raw Detail Level)

(Now you can create a slicer like normal.)

[Anonymous]

Hi @fhill Your solution worked on this case since data set was months. In my problome i have category like Country, Job Title and not the months. Can you help me solve my issue. I have posted here my issue:

https://community.powerbi.com/t5/Desktop/Slicer-by-columns-name/m-p/472373/highlight/true#M219544

THanks in advance

[adharia · Accepted solution]

Thankyou for the solution @fhill it worked out for me.