Hi All,
I have a table called 'Main Data' which shows data similar to the below:
Module No Owner Developed Reviewed Signed Off
1 A Yes Yes No
2 B No No No
3 C Yes Yes No
4 D Yes No No
5 A No No No
6 B Yes Yes Yes
7 B Yes Yes No
etc.
I have created a visual which shows the progress of each owner in all 3 columns together (counting all of the 'Yes' responses vs. the Total responses). I have done this by creating 2 measures:
Measure 1 (Current Progress) =
SUMX(
UNION(
SELECTCOLUMNS('Main Data',"ContainsYES", 'Main Data'[Developed ]),
SELECTCOLUMNS('Main Data',"ContainsYES", 'Main Data'[Reviewed]),
SELECTCOLUMNS('Main Data',"ContainsYES", 'Main Data'[Signed off])
)
,IF([ContainsYES] = "YES", 1, 0))
Measure 2 (Total) = (COUNTROWS('Main Data')*3)
Now I want a slicer on the page which can filter the data for only specific columns i.e. only developed or reviewed or signed off. But I have no idea how to implement this in PowerBI. The two ways I have tried so far have failed:
1) Using Field Parameters - this doesn't work as Field Parameters cannot replace the relevant data within my measures (parameters in measures is not yet supported in PowerBI)
2) Unpivoting columns - this solution creates chaos with my other metrics and visuals in the dashboard
Could anyone help me please?
Thank you!
