I need column based slicer

[Ayappan]

I have a set of data which has pass and fail.

I need a slicer which has data like Student 1 ,Student 2 ...

If i select Student 1 it should update my Donut chat with how many subject Student 1 got Pass or Fail or No data or Pass - Conditional

Thanks in Advance

[bcdobbs]

If Active/InActive is linked to the subject then go back to PowerQuery, remove the unpivot you previously did and then repeat the steps but this time select both the Subject column and the Active/InActive column before using Unpivot other columns.

[bcdobbs · Accepted solution]

Hi @Ayappan ,

I would start by transforming your data in power query (click transform data).

You need to select the subject name column and then use "Unpivot Other Columns". https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

this will give you a table with columns:

Subject, Student Name, Value.

Data in this form will be much easier to work with in Power Bi.

[Ayappan]

Thanks @bcdobbs 

That worked - After this  i had added a column with Active / InActive .

So now i have to Filters .1st with pass or fail 2nd with Active / InActive 

Should i follow same process or any other way it will help me .Please Suggest