Chart not existing in PBI. Is available in Excel

[BIuser09]

Had to post this here in the first place.

table below should give this chart in Power BI but in standard 'Line and stacked column chart' I cannot choose x axis for measure 1. Trendline on secondary axis is possible in PBI but that is not the result a I get in Excel custom chart.

I would like to add 'measure1' as a line or marker connected to the data on the FIRST Y axis. NOT the 2nd Y axis

Does this chart also exists in Power BI ?

data:

	1	2	3	4	5	6	7	8	9	10	11	12
dataA	10	15	35	20	45	40	5	35	20	45	40	60
dataB	20	15	35	10	5	5	5	10	35	55	50	35
dataC	50	40	55	40	60	65	55	40	70	65	65	40
running total	80	150	275	345	455	565	630	715	840	1005	1160	1295
measure1	65	70	85	85	80	90	90	95	85	90	90	100

Chart in Excel

[v-venuppu]

Hi @BIuser09 ,

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 other community members with similar problems can find a solution faster.

Thank you.

[v-venuppu]

Hi @BIuser09 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my 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-venuppu]

Hi @BIuser09 ,

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.

[v-venuppu · Accepted solution]

Hi @BIuser09 ,

You can try below options that will help to solve the issue:

Option 1: Normalize Running Total
If measure1 is important visually, and running total skews the axis:

Scale running total to a percentage or index (e.g., 0–100):

RunningTotalNormalized =
VAR MaxRT =
MAXX(
ALL('Sheet1'[Month]),
[running total]
)
RETURN
DIVIDE([running total], MaxRT, 0) * 100
This way, both measure1 and running total sit on comparable scales and you can still plot them together as lines.

Make sure to replace 'Sheet1' with your TableName.

Option 2: Use Deneb (Vega-Lite / JSON) Custom Visual

 Deneb is a custom visual that allows full chart control (like Excel or Tableau), including:

Multiple Y axes

Assigning axes independently to series

Customizing chart layout, style, interaction

You can Install Deneb from AppSource in Power BI using below link:

Deneb: Declarative Visualization in Power BI

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[v-venuppu]

Hi @BIuser09 ,

Thank you for the Response..!!

I have replicated the chart in Powerbi with sample data.

You can go through the attached .pbix file for your reference.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[BIuser09]

thanks for sending pbix but issue is same.

I cannot add 'running total' into graph, axe X is not possible (stacked), and axe Y is also not possible because of 'measure1' is in it and scale of numbers of 'measure1' and 'running total' are too different. It ruins the graph.

In excel it is possible.

[v-venuppu]

Hi @BIuser09 ,

Thank you for reaching out to Microsoft Fabric Community.

Yes, you can build this chart in Power BI.

Use a Line and Stacked Column Chart, place dataA,dataB,dataC in column values, and measure1 in line values. Then:

• In Format pane - Turn off secondary Y-axis.
• This keeps all series on the same (primary) Y-axis, just like Excel.

If your data is in wide format, unpivot it first in Power Query to make things easier.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[BIuser09]

Thanks for your answer.

But I still can't replicate the graph from Excel.

I have to delete 'running total' from graph otherwise large scale of this measure ruins the graph. Unpivoting won't help, data is what it is.

Really not another graph is suitable in Power BI ?