cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
AppleMan
Frequent Visitor

Adding total line to graph with multi item X axis

Hi,

 

I am currently trying to find a solution for a graph that I was requested to create. The user would like a graph that shows the items on the x axis broken down by year, and then by our different companies, which is easy enough to do. The issue is they also want a line on the graph that shows the total for each year (or basically all items for all companies rolled into one total). It seems to not be possible to do this since adding a second x axis item removes the line options in formatting. 

 

Here is a picture of what I was requested to create:

AppleMan_0-1695315777489.png

 

Here is what I have been able to create in powerBI, issue is, as soon as I add a second item to the X axis I am not able to add a trend or reference line, the option dissapears. 

AppleMan_2-1695316000635.png

 

 

The X axis needs to be split by a count, as well as year, while still retaining the option to add a line that I can code to show the total for each year.

Is there a work around for the line option disappearing with two x axis items? 

1 ACCEPTED SOLUTION
dlopesc04
Helper I
Helper I

Try this (using the native bar and line stacked chart):
Year on X axis
Sum of items on column Y axis
Sum of items on line Y axis
Company id on legend
Here's my result:

dlopesc04_0-1695322289237.png

 

View solution in original post

3 REPLIES 3
dlopesc04
Helper I
Helper I

Try this (using the native bar and line stacked chart):
Year on X axis
Sum of items on column Y axis
Sum of items on line Y axis
Company id on legend
Here's my result:

dlopesc04_0-1695322289237.png

 

That worked perfect, thank you so much!

Glad to hear it!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors