Slicer Not working

Question

Hi&nbsp;Need Help.&nbsp;I made a cumulative graph based on 2 different data sources.now i want&nbsp;slicer to affect all lines in the graph.but now,&nbsp;the slicer&nbsp;affects graph lines which is from same source. so i think it's about the relationship..!&nbsp;do you have anyidea what to do to get my desired result?&nbsp;Here is some sceenshots of my current report.&nbsp;&nbsp;&nbsp;

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
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.
&nbsp;
Regards,
Cherie&nbsp;

anonymous · Answer

Hi,&nbsp;It works! what way would it be for Module and SOW Slicers to work?

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
Yes, you may try the same way for the other slicers.
&nbsp;
Regards,
Cherie

anonymous · Answer

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

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
If you want to use&nbsp;Module and SOW Slicers to filter&nbsp;DP List and Table - JV(Piping).You may create 2 tables: Module table and&nbsp;SOW Table like&nbsp;Deck Order table.Then link the 2 tables with&nbsp;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
&nbsp;
Regards,
Cherie

Forum Discussion

Slicer Not working

6 Replies

Related content

Calculation not working when slicers applied

Sync Slicers Not Working Between Button Slicer and Standard Slicer

synchronized slicers not working online dashboard

Slicers not working!

Slicer doesn't work properly