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!
Dynamic Y-Axis on Line Charts
When creating an Line Chart using small multiples you can have several charts showing up within the "canvas" area of the line chart. Unfortunately the Y-Axis always set to the upper and lower bounds thus when you have disparate scales of really large and really small amounts the small values appear as a straight line, when in actuallity if the scale were smaller you would see a large dispersion between the minimum and maximum value.How do I make a line chart with an arrow pointing outward from the last data point ?
How do I make a line chart with an arrow pointing outward from the last data point (like the image below) OR have the trendline indicate the rise/fall with an arrow at the end of the line? I am not able to find such a feature? The closest thing that I can find is that you can make data points appear as circles, squares, triangles, cross,... etc under Format> Shapes > Show Marker. But sadly no arrow marker 😞 . Is there is a way to add like a custom marker ? or are there any custom visuals tha depict an arrow pointing at the end of the line in a line chart?
