Showing results for 
Search instead for 
Did you mean: 
Brianne New Member
New Member

Line Chart Summing Data rather than Showing Value


When creating a line chart in Power BI, the data continue to sum rather than show the decminal value. I have tried every iteration in the modeling tab of don't summarize, sum, average, etc. I change the data type to text, decimal number, percent etc. I can't get the lin chart to show the value for some reason. I also tried several iterations in the field colum where you can change what happens to the value. Does anyone have guidance on this?

Pbi Line Chart.JPG

Super User
Super User

Re: Line Chart Summing Data rather than Showing Value

Hi @Brianne,

Do you have any relation betweem date table used on the x-axis and the OBF table from were you are making the line?

When you use ywo different table that don't have a relation between them the result is the total value and not the distinct points.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 36 members 976 guests
Please welcome our newest community members: