Forum Discussion
Filtering projects with different parameters
I have a large and complex data set that holds information on a number of projects that are being carried out across the globe but the sites have a different status and there are multiple columns on each row with information that I would like to compare.
In the example below; Project 1 is ongoing at A&B sites, Project 2 ongoing at B sites only and project 3 at A sites only.
How would i set up a filter that can compare performance across projects at A&B sites only i.e. like project 1 and not include B only and A only projects in the analysis. Currently on Power BI if I can only get performance across all groups so aggregare data will include all A's and all B's in the analysis and i would only want to compare the performance of A and B sites when the project includes both.
Example:
| Project number | Site type |
| 1 | A |
| 2 | B |
| 1 | B |
| 1 | A |
| 3 | A |
| 3 | A |
| 1 | B |
| 1 | B |
| 2 | B |
1 Reply
Hi , SGB
I'm a little confused by your description.
You example is just a table.I hope you can explain what effect you want the slicer to achieve in more detail .
Sample data and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Best Regards,
Community Support Team _ Eason
