Line chart from Excel always shows flat line / bar for one table, summing up all values
Hi, Apologies if this has been covered before, I read many posts, but none had quite the same scenario. Using Power BI Online, I want to compare download numbers for an app, as well as a comparison of won / lost users, so a (stacked) line chart seems best. The data will always be for the constant stream of date and then varying values per OS. My data comes from an Excel, I have tried data (date in column a, numbers in column B) in one worksheet or distributed over two worksheets, the problem remains the same. The first set of values is displayed as desired, a zig-zag line on the Y axis depending on the value for a date on the X axis. However, the second set of values always sums up all values for the available dates, creating a flat line (or bar in a bar chart). Why is this happening? A stacked area chart with the exact same data works, I don't get it -.- Any help is appreciated - this seems fairly straightforward, although it's my first attempt with Power BI. Thanks!
