Line CHart

[kaleenasanford]

Hey There,

I am stumped and hoping for some feedback. I am attempting to create a line chart that will measure out Interest Rates, Housing Prices and Municiopality population. Since you I can only have two Y axes, have modelled with housing prices and interest rate - so now trying to measure popluation growth to these two axes. Is this possible?

[rajendraongole1 · Accepted solution]

Hi @kaleenasanford - when you want to visualize three different metrics like Interest Rates, Housing Prices, and Municipality Population on the same chart. it is difficult and not supported by line chart alone. 

can you try Line and Column Chart

Plot these as line series on the chart, utilizing the two available Y-axes. You can represent this as a column series using one of the Y-axes. 

OR you can use tooltip -Use tooltips to display the third metric when users hover over data points in the line chart. OR drill through -Set up drill-through actions where clicking on a data point in the line chart allows the user to view a detailed report approach as well

Hope it helps.

[ahadkarimi · Accepted solution]

Hi @kaleenasanford, if this is what you were looking for, let me know and I can share the file with you here:

[Anonymous · Accepted solution]

Hello,rajendraongole1  and ahadkarimi .

Thanks for your concern about this issue. Your answers are excellent!
And I would like to share some additional solutions below.
Hi,@kaleenasanford .I am glad to help you.
As rajendraongole1 mentioned, the default visual can only hold up to two y-axis values, and after discussing your needs with the rest of the team, I think using a custom visual object would be a good option as well. I recommend you to try this visual.
It supports displaying multiple Y-axes in one chart, up to 5 Y-axes. This means you can show interest rates, house prices and municipal population data in the same chart.
It also offers a variety of advanced formatting options, annotation features, dynamic sorting, and interactive filtering, making it ideal for scenarios where you need to compare and measure different data sets.
Here is the link about it hope it helps you.

URL:
Multiple Axes Chart - XViz (microsoft.com)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ahadkarimi · Accepted solution]

Hi @kaleenasanford, if this is what you were looking for, let me know and I can share the file with you here:

[rajendraongole1 · Accepted solution]

Hi @kaleenasanford - when you want to visualize three different metrics like Interest Rates, Housing Prices, and Municipality Population on the same chart. it is difficult and not supported by line chart alone. 

can you try Line and Column Chart

Plot these as line series on the chart, utilizing the two available Y-axes. You can represent this as a column series using one of the Y-axes. 

OR you can use tooltip -Use tooltips to display the third metric when users hover over data points in the line chart. OR drill through -Set up drill-through actions where clicking on a data point in the line chart allows the user to view a detailed report approach as well

Hope it helps.