Line values on the same axis as the measured items

[ilied]

Hi,

I'm very new to Power BI, so this is probably an entrylevel problem for some of you, but I just can't figure this out.

My problem is this: I have data tables from two different sources. SQL Server and a Sharepoint Online List. The clustered column chart i'm making is showing how much product is being produced weekly. That data comes from the SQL Server. I also wanted to create two Line values, that show the amount of product that needs to be produced in that particular week. This amount is set via Sharepoint by the factory supervisor. Sounds simple enough so far. I managed to create the graph of the produced products and it looks good. I also managed to get the Line value from the sharepoint source. The problem is, the Line value is on a different Y-axis than the produced goods. They need to be on the same Y-axis. I attached screenshots below that should clear things up a bit. Is there a way to have only one Y-axis (which would be on the left side), so that the maximum value is the line value, or the value of produced goods, if it's larger than the set line value?

Hope this made sense.

I highlighted the problem. The line values are on the axis on the right and the produced goods are on the leftThis is the code for the measurement for one of the line values.

As you can see, the produced goods are separated into two categories and there are two Line values for each of these categories.

[MFelix · Accepted solution]

Hi @ilied ,

On the options nof the Y axis turn off show secondary, that will turn off the second line axis.

[ilied]

Thanks a lot! It actually was off, but when I turned it on and off again, it started working. Can't believe I didn't try that before.