Filtering only one axis

[MrAndrewth85]

Hello.

I am trying to use a line and clustered column chart to show the account balance amount by month in 2021. In the same chart, I need to show the total deposits by month, and for this I need to use a filter named "First record = 1", but I want to use this filter ONLY for the second Y-axis. I need that the first Y-Axis is not affected by this filter. How can I do this?

Thank you!

MrAndrewth

[lbendlin · Accepted solution]

Create a measure for the Total Deposits value that includes your filter criteria.