How can I filter out a line chart with two different slicers that have the same field

[fabjolakasaj]

Hello!

I need some help with building two comparison tables and a common graph on the side. Each table has two slicers, each of them has the same field. I am comparing the same cars but different ages. vehicle type slicers interact with each other but vehicle age slicers don't. This way I am getting my comparison in two different tables. Till this point it working well. 

I need to add a line chart graph that combines the result of these tables. So, if I am selecting the first age group "0-3" and the second one "4-6" , I need the graph to show two different lines for each age group. Right now, when I select the second age group the graph is blank.One age group selectedTwo age groups selected

[v-xinruzhu-msft · Accepted solution]

Hi @fabjolakasaj 

Since you have filtered the data from 0-3 months, now the view has filtered out other months according to your filter, and only shows 0-3 months, so when you filter the data from April to June with another slicer, it is equivalent to filtering in the data from 0-3 months that has been presented now, but the data does not contain the data from April to June so it returns null values. The best approach is to create another line chart that shows the data filtered by two filters and sets up the interaction so that it is not affected by slicers on both sides.

You can refer to the following link to know how to set interaction.

Change how visuals interact in a report - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.