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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
b_minesh
Frequent Visitor

Line Chart without Aggregated Values

I have the following data - 

 

line.PNG

 

I am trying to plot a line chart and Power BI gives the output in the form of aggregation as shown in the image below.

 

agg.PNG

The field values menu does not give me a "don't summarize" option to select my value as it is, without any form of aggregation or calculation. Additionally, it changes the y-axis to decimals and it should show whole numbers. I need it to look like the image below - 

lineop.PNG

How can it be achieved? Please help

 

Thank you!

 

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @b_minesh 

The line chart is plotting categorical data and you have multiple blank categories.  What is the chart supposed to do with those?  

I don't see how you get your desired result from your sample data.  All of the named Rater Groups have value 3 - but your desired result shows Peer and Direct Report with a vaue of 4?  And Others with a value of 3?  Based on your sample data the PBI chart is correct.

You have blank Rater Groups, how are they supposed to be treated?

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors