How to make column & line on the same axis in power bi?

[Maahmohammed]

Please, to be on the same axis not on the 2ry axis?

[v-shamiliv]

Hi @Maahmohammed 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-shamiliv]

Hi @Maahmohammed 
I wanted to check if you had the opportunity to review the information provided by @rohit1991  and @Ritaf1983 . Please feel free to contact us if you have any further questions. If their response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-shamiliv]

Hi @Maahmohammed 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[rohit1991]

Hi @Maahmohammed,

In Power BI, if you want to display both a column and a line on the same (primary) axis rather than using a secondary axis, you can achieve this by carefully configuring the visual. Start by using the “Line and clustered column chart” visual. Add your column values to the "Column values" field and your line values to the "Line values" field as usual.

Then, in the visual formatting pane, go to the "Y-axis" section and disable the secondary axis by toggling off the “Show secondary” option. This will force both the column and line values to share the same Y-axis, making it easier to compare them directly on a unified scale. Just ensure that the magnitude of both values is reasonably aligned; otherwise, the chart might become hard to read due to scaling differences.

[Ritaf1983 · Accepted solution]

Hi @Maahmohammed 

---

Unfortunately, Power BI doesn't support placing both columns and lines on the same axis—this is by design. The visual is structured with a primary axis for columns and a secondary axis for lines.

However, here are a few alternative approaches you can try depending on your use case:

1. Align Axis Ranges: You can manually set the minimum and maximum values for both axes to create the appearance of alignment and proportionality.

2. Use Reference Lines: If the line represents a constant or has minimal variation, you might use a reference line instead of a line series.

3. Use Error Bars: If you're trying to show markers (e.g., for min/max or specific values) rather than a continuous line, error bars can serve as a creative workaround.

To give you a more targeted solution, it would help to understand what exactly you're trying to achieve with this combination.

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