Filtering data

[Anonymous]

Hi,

I'm relatively new to power BI. I have two data sets, im trying to use one to filter what is show in a report. Simplified example, data has common index.

data set 1:

index	name	status
0	example 1	new
1	example 2	ready
2	example 3	ready
3	example 4	new
4	example 5	new

data set 2:

index	segment 1	segment 2	segment 3	segment 4	segment 5	segment 6
0	x					x
1
2	x	x	x	x	x
3						x
4						x

I want to be able to choose a "segment" and view the resulting "name", and "status" values which apply as indicated by the "x". 

Any tips or best practice for how to combine or transform the data to achieve this would be great!

[Anonymous]

thanks. let me re-phrase the question into a single table

name	status	segment 1	segment 2	segment 3	segment 4	segment 5	segment 6
example 1	new	x					x
example 2	ready
example 3	ready	x	x	x	x	x
example 4	new						x
example 5	new						x

I want to be able to slice or otherwise filter to just see results from everything that has an "x" in segment 1, or segment 2 and so on.

if i pull them into a single table and make a slicer for each item I end up with something like

rather than a slicer with the list of segments which is what a want to filer on, such as

title: Segments

 * segment 1

 * segment 2

 * segment 3

[JirkaZ]

still confused - how does the raw data look like?

[Anonymous]

I'm unable to post the raw data, but it has the same structure. This one to many aspect which i want to use for filtering. I'll keep searching and see if i can present it in a different way or otherwise solve it. Thanks!

[JirkaZ]

I'm sorry but I don't see the logic for the visual. How does the first table relate to the segments in the visual?