Chart interactions - specific field for filter

[TCavins]

In a clustered column chart, my X-axis is the Month Name. The legend is Fiscal Year. When a user clicks on one of the columns for any month, I want the month only to filter another chart that uses the exact same dataset.

What I'm getting is the Month and Fiscal year being filtered so the second chart only shows one column instead of each fiscal year for that month.

Is there a way to set up the interaction to only use month to filter the second chart?

[parry2k · Accepted solution]

@TCavins if you click on a data point it will filter on year and month but if you click on month value on x-axis, it will show all fiscal year for that selected month,

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[TCavins]

Excellent. Thank you! I forgot you can click on the axis as well. Looks like just user training to get it working.

Thanks again!