Help with filtering data in the report

[luvarap]

The  "Data" table is in power bi is shown below

Data Table

Weight	Palletization	Workmanship standard
Full Compliance	Partial Compliance	Partial Compliance
Full Compliance	Partial Compliance	Full Compliance
Partial Compliance	Not Applicable	Full Compliance
Zero Compliance	Full Compliance	Full Compliance
Not Applicable	Partial Compliance	Partial Compliance

I would like to have a slicer filter with the following options 

• Full Compliance
• Partial Compliance
• Zero Compliance
• Not Applicable

The filter selection depending upon the chosen option(s) would produce a report of the total count for each options as follow -

	Full Compliance	Partial Compliance	Zero Compliance	Not Applicable
Weight	2	1	1	1
Palletization	1	3		1
Workmanship Standard	2	3

 I created another table having single column showing selection options for slicer filter but in absence of any relationship between this created table and data table the filtering would not work.

Is there any way to accomplish this? Any help is appreciated.

[luvarap]

Thank you. The problem is I am getting the data from Microsoft forms and the way it is structured is as given in data table. And, I have shown only 3 columns but there are about 30 columns with similar headings.

[andhiii079845 · Accepted solution]

You can do it in Power Query Editor. So the source has the same structure and your dataset for the report a other. 

[luvarap]

Thank you for your help. I will try it out per your suggestions.

[andhiii079845]

I would bring the raw data table in a other structure. Than it is easier to make the calculation. You can do it via Power Query Editor. 

Type	Value
weight	Full Compliance
weight	Full Compliance
weight	Partial Compliance
Palletization...	Not Applicable...

[luvarap]

Thank you for your response.

You mean create another table with data table headings and its all possible values in value column?

[andhiii079845]

Yes! 🙂