Creating a slicer out of Column Headers

[Anonymous]

Hi there power bi masters, 

How can i create a slicer using the column headers? I tried using unpivot columns but the result was not what I wanted. 

I wanted, the slicers to have OS1, OS2, OS3, OS4, OS5, OS6, OS1-6, File-Based, Smart Lexi. These are supposed to be channels.

Can please assist? Also i wanted both charts to interact with each other when the channels are selected like just show the cost and the hours of only selected channel. But at the moment it is not working properly. I suspect is how the data is formated. Tried changing in edit interactions but no luck. Thanks again. 

PBIX 

[Anonymous]

@danextian @Ritaf1983 any chance of opening and checking out my pbix? Appreciate your help. Thanks

[danextian]

Hi @Anonymous ,

I am unable to open the pbix. But you can use filed parameters or try the approach in the attached pbix.

[Anonymous]

Hi there, I have tried the field parameters...but somehow still not showing i want it to. 

https://drive.google.com/file/d/1k67h5zqGUn6b_5CxlzrA-xrCWgSIF92X/view?usp=sharing 

[danextian · Accepted solution]

Hi @Anonymous ,

In the query editor, you can select the columns that you don't want to unpivot, right click and then unpivot other columns. That should put the column headers in a column and the values in another so you can easily slice and dice them. Please see attached  modified pbix.

[danextian]

I still can't open the pbix. You must remove the sensitivity label.

Also, have you tried the approach in the pbix in my previous reply?

[Anonymous]

i did try it but not sure how to achieve what i want. tried a few combinations. maybe i need to format my data set? hopefully now the link works. sorry for being a noob. 

pbix 

[Ritaf1983]

Hi @Anonymous 
There is no access to the linked pbix , but if the goal is to choose the columns to show, you can use field parameters.

https://www.youtube.com/watch?v=-nqEv2YXLsU

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous]

Thanks for the video. will check it out. Apologies for the link. It should be working now.