Dynamic filtering using Slicers

[Durangodata]

Hello BI Wizards,

I have a strange question that I am looking for a solution... I dont know if Im going in circles or is this really a tricky requirement.... and was wondering if you could help 🙂 , here goes -->

I have 2 tables

Tab 1

Project Name	Project Status
Proj 1	Green
Proj 2	Green
Proj 3	Yellow
Proj 4	Red

Tab 2

Project Name	Project Status
Proj 5	Green
Proj 6	Yellow
Proj 7	Yellow
Proj 8	Green

The requirement is to only have a Project Name Slicer from Tab 1 in the report. And the result should be a common table of the selected project from Tab 1 + projects from Tab 2 having the same Project status. So for example if the selected slicer value is Proj 3 , the result should be as below since the Project Status for all the three projects is Yellow:

Project Name

Proj 3

Proj 6

Proj 7

Any nudge in the right direction would be highly appreciated! 

Thanks,

Chaitra

[lbendlin]

You're going in circles because this is not currently possible in Power BI/DAX.  You cannot dynamically  (ie based on a measure or filter selection) create data rows (as would be needed in your case) you can only dynamically take away (filter) data rows.

If you want to cheat then you can combine these tables during the data load, and then use filters to make it look like they were still separate.