Forum Discussion

mshashmi's avatar
mshashmi
Frequent Visitor
9 years ago
Solved

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 wor...
Need Help
  • cs_skit's avatar
    cs_skit
    9 years ago

    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

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

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's avatar
mshashmi
Frequent Visitor
9 years ago
This can't be done as both tables contain entirely different data. So what should I do?
  • cs_skit's avatar
    cs_skit
    Resolver IV
    9 years ago

    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's avatar
      cs_skit
      Resolver IV
      9 years ago

      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