Slicer Not working

[colourfullife]

Hi

Need Help.

I made a cumulative graph based on 2 different data sources.

now i want slicer to affect all lines in the graph.

but now, the slicer affects graph lines which is from same source. so i think it's about the relationship..!

do you have anyidea what to do to get my desired result?

Here is some sceenshots of my current report.

[v-cherch-msft]

Hi @colourfullife 

It seems you may try to use Deck Order table as slicer table.Link it with the DP List and Table - JV(Piping).Then use Deck column in Dexk Order table as slicer to filter the two tables.

Regards,

Cherie 

[colourfullife]

Hi,

It works! what way would it be for Module and SOW Slicers to work?

[v-cherch-msft]

Hi @colourfullife 

Yes, you may try the same way for the other slicers.

Regards,

Cherie

[colourfullife]

hmm then among slicers, it wouldn't work.?

[v-cherch-msft]

Hi @colourfullife 

If you want to use Module and SOW Slicers to filter DP List and Table - JV(Piping).You may create 2 tables: Module table and SOW Table like Deck Order table.Then link the 2 tables with DP List and Table - JV(Piping) like above way.Use the 2 tables column as slicers.Below are some articles for your reference.

https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships

http://radacad.com/what-is-the-direction-of-relationship-in-power-bi

Regards,

Cherie

[colourfullife]

I made a exact same table for deck and make relationship as below.

But, it doesn't work...? any idea?