Stacked and Line Chart

[mshashmi]

Hi

I have made a stacked line chart. In this, stacked columns are coming from one table say table1 whereas line chart data is coming from another table, table2. Now if I apply a slicer, it works only on stacked columns as value in slicer is coming from table1 and not table2. But I need the line chart to also change according to the slicer. Is that possible and if yes, then how?

Thanks

[Thiyagu]

Hi @mshashmi,

Do you have a valid relationship between this table 1 and table 2?

[mshashmi]

There is no relationship present between these two tables. Can it be done or not?

[cs_skit]

If you have some kind of Category you want to slice on that exists in both tables then its probably best to put that into your data relations.

Create new table that is a result of a merge distinct of the category fields from both tables then draw relationships from the new table to your two tables 

[mshashmi]

This can't be done as both tables contain entirely different data. So what should I do?

[cs_skit]

Can you show us your Tables?

If theres secret stuff blur/grey out parts of it but it would help to see the structure.

[cs_skit · Accepted solution]

btw my solution does not care if the data is completely different

here the new table you have to create under Modeling - New Table:

then just drag the relationship to both tables here is my example data:

the slicer can slice through data from both tables