Use Headers as slicer

[FatBlackCat30]

Hi all,

I have data that looks like this (below) and I want to create a slicer that contains all names in the headers (pcusers, nonpcusers,andriodusers, iOSusers) I found some examples but they are not working for me. any suggestions on the best approach to do this?

thanks! 

date	pcusers	nonpcusers	androidusers	iOSusers
11/15/2020	1%	44%	54%	45%
11/16/2020	3%	33%	45%	54%
11/17/2020	3%	53%	14%	15%
11/18/2020	6%	53%	15%	23%
11/19/2020	4%	23%	34%	33%
11/20/2020	9%	22%	53%	90%
11/21/2020	5%	22%	33%	43%
11/22/2020	3%	12%	45%	60%

[Icey · Accepted solution]

Hi @FatBlackCat30 ,

Please check whether this could meet your requirements:

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[FatBlackCat30]

thank you this is xactly what I was looking for 

[colacan]

@FatBlackCat30 

Hi, 

No worry, unpivoting does not cuase any data loss. actually this process (Unpivoting) is required for all pivoted tables to use Power BI efficiently. 

With Excel, we usually use(like) pivoted table, but power BI mostly uses unpivoted table.

Hence, if you will use Poer BI, I recommend to get familier with it.

Hope this helps. Thanks.

[colacan]

@FatBlackCat30 

Hi,

First, you need to Unpivot the the table (except Date header) as below;

1. Home > Transform Data

2. Select the data table and unpivot all heards except Date

3. Close and apply and Create Slicer

Hope this helps you.

[FatBlackCat30]

Hi @colacan Is this possible without unpivoting? Sorry I should have clarified that

[MattAllington]

Unpivot the data in power query. Click the date column, then "unpivot other columns". This will give you and attribute column and a value column. You can use attribute in your slicer

[FatBlackCat30]

@MattAllington is it possible to do this without unpivoting the data?