Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Line Chart Summing Data rather than Showing Value

Hello,

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?

1 Reply

  • Hi Anonymous,

    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.

    Regards
    MFelix