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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
niccolo_guazz
Regular Visitor

line plot legend sum of

Hi.

I am facing a style issue plotting a dataset like the one below.

niccolo_guazz_0-1670178547060.png

When plotting a simple line plot, like the one below, in the Y axis field I cannot choose to plot the single values, but the options as below. Since I am plotting all the values for all the X axis period, if I choose SUM I exactly get the point by point value. But I don't think this is the correct way to plot. Indeed in the legend I read SUM of something. I would like to have only "something".

Any idea?

 

niccolo_guazz_3-1670178866079.png

 

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@niccolo_guazz In the Visualizations pane, double-click the value in the Y-axis field well and rename to "something"



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

@niccolo_guazz In the Visualizations pane, double-click the value in the Y-axis field well and rename to "something"



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thank you @Greg_Deckler .

Is it normal that with a dataset like this, if i plot a line-plot the only way to display a let's say "normal plot" is to sum y values for each x value? (let's say different from an Excel approach)

Thanks.

x-axisy-axis
11
22
33

niccolo_guazz_0-1670185356520.png

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors