I am trying to create a chart as below where the requirement is to show cumulative current and previous month values for multiple measures in one sheet in circle and the bar shows till the present value. I am able to show circle and bar in the end using lollipop chart but unable to show previous month value in different color in same sheet.
Can somebody please help?
Thanks in advance.
Usually tasks like this are best achieved with 3 sheets brought together in a common dashboard. What is the limitation for a single sheet imposed for?