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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

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


@ 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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.