Double axis line

[Marshmallow]

Hi, I am trying to work out how to create a double axis line. Sampe data as below:

Company	Date Approved
A	26/3/2025
B	26/3/2025
C	13/12/2024
D	30/6/2024
E	1/05/2024
F	1/05/2024
G	3/2/2024
H	3/2/2024

How do I create a dual axis line that shows:

 X  axis - month

 Y axis - Total approved

One line shows total approved for FY 24/25, another line shows total approved for FY 23/24

[v-priyankata · Accepted solution]

Hi @Marshmallow 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@danextian Thanks for the inputs
As suggested by @danextian, I have reproduced the scenario. Please take a look, and if you encounter any issues, feel free to reach out to the community.

Thanks.

[v-priyankata]

Hi @Marshmallow 

I hope the information provided was helpful. if any releted ans please accept it as solution, If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @Marshmallow 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @Marshmallow 

Hope everything’s going smoothly on your end. We haven’t heard back from you, so I wanted to check if the issue got sorted. if you have any other issues please reach community.

[ryan_mayu]

@Marshmallow 

what's the expected output based on the sample data you provided?

[danextian]

Hi @Marshmallow 

Your table must have an identifier whether a date is in a specific FY then add that identifier column as a legend.