Filter Visual by Different Columns

[Anonymous]

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!

[lbendlin · Accepted solution]

Unpivoting is the right thing to do in most cases. See if you can overcome the chaos by adjusting the rest of your report.  

[Anonymous]

Hi, yes you are correct, I managed to overcome this issue through unpivoting the selected columns within a duplicate version of the same dataset (so my other visuals were not affected). Thank you 🙂