Line and Clustered Column Chart Filtering

[juanvelez]

Hello,

I have a line and column clustered chart which displays data for 3 separate years and also a slicer that filters the data per year. The problem I'm having is that when I filter the data for a specific year my chart shows me the 3 years but only the data of the one that I filtered. What I want is for the chart to filter also the axis that shows the years, so that it only shows the year that I filtered.

I would really much appreciate if someone could help me.

Thank

[Anonymous]

@juanvelez,

Is the date field of the slicer same as that you put in x-axis of the chart? If yes, when you select values in the date slicer, the chart will be filtered to show relevant years.

However, if you use different date fields of different tables to create the slicer and the chart, make sure that proper relationship has been established in the two tables. Otherwise, the chart will not filtered correctly.

We will appreciate that if you can share us PBIX file.

Regards,
Lydia