Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Dual y-axis customize units by series

I have this report with four series: average salary of quarter, average salary of last 12 months, total retail turnover in current prices and total retail turnover average of last 4 quarters. 

I am trying to recreate PowerPoint graphs in PowerBI and I have problem with this specific graphCapture3.PNG

Specially with the average salary of last 12 months. As you can see, I on the left I have turnover in millions compared to salaries in just euros. I created a similar one in PowerBI:Capture1.PNG

As you can see I put average salary of last 12 months into column values, so it would be in just euros not millions, but I want to show it as a line as in line values. If I put it in the line values:

Capture2.PNG

I put it in line values and it is shown with black colour. So the problem is, I can change y-axis values by column values and line values, but is it possible to see average salary of last 12 months NOT in millions like other line values are? 

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

In Power BI, after we turn on the Show Secondary option in a combo chart, we can set columns/measures in Line Values to display separately based on the same Y-Axis scale, but it's not able to set all line values to show based on different scale. 

 

In your scenario, if you put average salary of last 12 months in Line Values bucket, it will use the same scale as other line values, it's not able to set different for this measure compares to other line values. 

 

Best Regards,
Qiuyun Yu