How to slice data in table by Column Criteria. Equipment by Column Names and X denoting trained.

[Ishmale]

Hello Community,

I have data in a Sharepoint List and I am querying it into my PBIX file. I want to be able to slice the data from the list within a table based on "X" within that column. This dashboard is to show frontline supervisors their team and what they are trained on and then have the ability to request training from the dashboard for the selected associate.

My Data is set up as follows: 

I would like for Bi to slice my data based on wether or not that a person is trained on the equipment without having to make individual slicers for each equipment column. Currently I have not found a way to do this myself and would be open to ideas.
Look I am going for:

[Anonymous]

Hi @Ishmale ,

Try unpivoting these columns.

Then add a filter like this to the visual:

Output:

Please check the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[PijushRoy]

Hi @Ishmale 

Please share sample data and screenshots of your requirements. Better if you create one pbix file and share it with me, I can quickly look into this.

Thanks

Pijush

[Ishmale]

How can I share the PBIX file with through the site?

[PijushRoy]

Hi @Ishmale 

Upload in google drive and give access for all, then share the link
Notes - please share only non sensitive data

[Ishmale]

https://drive.google.com/drive/folders/18PkBPZHjGiudg9gu8eSMoGNuCpqXqsjm?usp=drive_link

What I am looking to do is simply Be able to filter my data by Supervisor, NAme, or Equipment a person can drive.

The Equipment Types are the Column names and if an employee is trained on it the SP List has in "X" in that Column(Excel Sample Data)

[PijushRoy]

Hi @Ishmale 

In the share option, please allow for all access

[Ishmale]

Done

[PijushRoy]

@Ishmale  Looking into it

[Ishmale]

Thank you.

[PijushRoy]

Hi @Ishmale 

Please find the screenshot and pbix file link

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

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

[Ishmale]

Checking Now!

[PijushRoy]

Hi @Ishmale 

I think you are looking for Field Parameter.
Field Parameter will give you option for Column in Filter/Slicer
Please check this below Articles
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

https://www.youtube.com/watch?v=Gkuq0jTAKj4

If your requirement is solved, please MARK this answer as SOLUTION

Thanks
Pijush

[Ishmale]

Not Quite what I am looking for.

I want to filter the Names by if they can drive not just show the "X" when equipment is selected

I am loooking more for something like the following:
IF turrent Truck is selected then only Name 5, Name 17, and Name Name 9 should be shown since those are the only names that should be able to drive the turret truck.

[PijushRoy]

Hi @Ishmale 

Please find this https://drive.google.com/file/d/1vkhOLXl3_SvUq-pSFD9c5hT3ydPU3RLe/view?usp=sharing

If solved your requirement, please mark this answer as SOLUTION.
If this comment helps you, appreciate your KUDOS

Thanks
Pijush

[Ishmale]

Thank you, PijushRoy.

This is not my preferred method I did know I could do it in this way. However I have over 700 employees in my source data and this method would not be good for simplfication. I appreciate the help with this I might need restructure my sharepoint list to achieve my goals.

[Ishmale]

Would I be able to add if Value = "X" to the parameter?

[Ishmale]

Thank you,
I have tried using the parameter function but it did not work as intended because it did not filter based on if the "X" was in the column or not.

How should I set that up? I feel like this might work but it just need to get to the next step.