https://community.fabric.microsoft.com/t5/Report-Server/Filtering-only-one-axis/m-p/2365576#M23097 <P>Hello.</P><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you!</P><P>&nbsp;</P><P>MrAndrewth</P> Mon, 28 Feb 2022 20:42:31 GMT MrAndrewth85 2022-02-28T20:42:31Z https://community.fabric.microsoft.com/t5/Report-Server/Filtering-only-one-axis/m-p/2365576#M23097 <P>Hello.</P><P>&nbsp;</P><P>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?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P><P>Thank you!</P><P>&nbsp;</P><P>MrAndrewth</P> Mon, 28 Feb 2022 20:42:31 GMT https://community.fabric.microsoft.com/t5/Report-Server/Filtering-only-one-axis/m-p/2365576#M23097 MrAndrewth85 2022-02-28T20:42:31Z https://community.fabric.microsoft.com/t5/Report-Server/Filtering-only-one-axis/m-p/2368490#M23120 <P>Create a measure for the Total Deposits value that includes your filter criteria.</P> Tue, 01 Mar 2022 22:09:35 GMT https://community.fabric.microsoft.com/t5/Report-Server/Filtering-only-one-axis/m-p/2368490#M23120 lbendlin 2022-03-01T22:09:35Z