Need Help On Filtering a Line Chart Correctly

[gadao]

Hi there,

Need some help in situation here.

I have a Bar chart with a rate in Y axis e and names in the X axis, this chart is filtered to display the last date available.

I have created a line chart to display the full period, basically the same chart, but instead of names in X axis I have dates now.

I would like to click in the names in first chart and this filter only that name in the second chart.

But since the first chart I did using the filters, when I click in any name the second chart filters that name but also the date, displaying a point in the chart.

I tried to replicate the filter behavior using DAX, but I wasn't successful.

Any Ideas of how to do it?

[Anonymous · Accepted solution]

Hi @gadao ,

You could create an independent date table and create an inactive relationship between the fact table.

Create a measure use USERELATIONSHIP() function in first visual.

USERELATIONSHIP function (DAX) - DAX | Microsoft Learn

Then the first visual will filtered by date from new table but the second visual won't.

Best Regards,

Jay