Forum Discussion

StaticElectric's avatar
StaticElectric
Frequent Visitor
5 years ago
Solved

Calculation Groups and Dual-Axis Line Chart

Hi,

 

I am in the process of implementing calculation groups. I have used Macro's sqlbi article and video (Creating Calculation Groups in Power BI Desktop - SQLBI) as a guide and everything is working well. My measures are:

 

1) CY

2) PY

3) YOY

4) YOY % Change

 

I would like to use the line chart to show CY, PY and YOY% change. Currently, all items use the primary Y-axis. I want to show the % change on the secondary y-axis. Is this possible? I have a feeling that I maybe overlooking something straight-forward. I have searched for articles, however, I was not able to find relevant information. 

 

Thank you.