Forum Discussion
Stacked and Line Chart
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
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
6 Replies
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
- There is no relationship present between these two tables. Can it be done or not?
