Forum Discussion
Cumulative Sum Graph with Labels
The graph and your data are very hard to understand Rajeev. Are you sure that a line chart is the correct chart here? Usually a line chart is only used when one of the dimensions is time based...
Hi Jaap,
I'm using numbers and not time on X -axis. I need to show the brand labels on the line chart like below. Is it possible to achieve the below graph. I have used scatter plot to show the lables (Category labels) unfortunately we dont have connecting line to join the bubbles (Like in Excel Scatter plot with line).
Yeah I still don't think that a line chart is appropriate here. LO and PO are now connected to each other for no reason, they have no more relation than NU and PO. A scatter chart is the correct chart here, the lines should not connect to each other. This is probably also why PowerBI doesnt allow you to put labels there, because it doenst make sense in a line chart....
If you have a line chart per day, and you have the following values:
1-1-2017 50
2-1-2017 100
You can put a line between those two values, because you're showing a rise in the value over time. In your example, there is no rise from LO to PO, they are unrelated, so there shouldn't be a line.
My recommendation would be to create a group for all the online and offline values, and use that group ID to determine the colour of the dots in the scatter plot (you can put this group value in the "legend" box. Then you will see which products are online and offline, and you have the brand names once you put the brand names in the "details" box.