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

The 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.

Reply
mshashmi
Frequent Visitor

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

1 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

View solution in original post

6 REPLIES 6
Thiyagu
Helper III
Helper III

Hi @mshashmi,

 

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

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

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 

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

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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