Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
colourfullife
Post Partisan
Post Partisan

Slicer Not working

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.

Capture.PNGRelationshipp.PNG

 

 

 

6 REPLIES 6
v-cherch-msft
Microsoft Employee
Microsoft Employee

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 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

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

Hi @colourfullife 

 

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

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

doesn't work.PNG

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.