Line Graph Y2 axis

[PBIMike]

Hello,

I have data with just 3 columns: date / currency / fx rate.

Most of my currencies fall between 1.2 and 1.9, so work well on the y-axis. Japanese Yen, however, is between 130 and 150. I would like to plot this on the same line graph, but using the Y2 axis on the right. However, none of these fields can be dragged into the Y2 data field.

Is it possible to achieve this?

Many thanks,

Mike

[amitchandak]

@PBIMike , it was part of March 2020 release , refer

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/#_Dual_axis

[PBIMike]

Thanks Amit, but I'm afraid that doesn't solve my problem, as all the link says is to "drag fields into the new secondary Y-axis field". have tried dragging in every field, and none of them will remain under the Y2 heading.

I suppose my problem is that I want to use the same values for both y-axis and y2, but with one filtered to only apply to Japanese Yen, and the other to apply to all currencies.

Will Y2 only work when using a single data source, with a 2nd column of values?

Many thanks,

Mike

[v-lionel-msft · Accepted solution]

Hi @PBIMike ,

Like this?

FXATE_Japan = 
IF(
    [Currency] = "JPY",
    [fxrate],
    BLANK()
)

FXRATE_Non-japan = 
IF(
    [Currency] = "JPY",
    BLANK(),
    [fxrate]
)

Or like this?

If you use 'Secondary values' label, you can't use use 'Legend' label.

Perhaps this is the best way.

Best regards,
Lionel Chen

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

[Anusha321]

Hello,

I have Exchange Rate and Dimdate data and have to create a line chart with the data. And I'm using Region and Country slicer where the line chart shows the sum of exchange rate(Y axis) not individual exchange rate for respective Country.

Please help me with this.

Thanks

[PBIMike]

Thank you that looks incredibly helpful - i'll give it a go!