Placing multiple series on a line chart with different value ranges

[Kimcha]

Hi,

I would like to replicate the google search console report that shows multiple data series in one graph like this:

As you can see it is showing data from different ranges in one graph closely together. This allows you to see how they affect eachother.

When I try to replicate it in PBI, I get a charge like this where it is very difficult to compare the values:

Does anyone have an idea how to solve this?

[v-yulgu-msft · Accepted solution]

Hi @Kimcha,

In Power BI, this is a default behavior. As all series added to a single chart share the same Y-Axis, and it is not able to add a secondary Y-axis, there will exist a big fall between the "impressions" and "ctr measure". Currently, it is not available to change it.

As a workaround, you may try "Line and clustered column chart" which has a secondary Y-axis.

Regards,

Yuliana Gu