Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter Visual by Different Columns

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"10))
 

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!

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

2 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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 🙂