Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
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
Can you show us your Tables?
If theres secret stuff blur/grey out parts of it but it would help to see the structure.
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
User | Count |
---|---|
134 | |
72 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |