Please find the attached workbook for your reference.
Steps are below
1st - Create the below view
2nd - Go to show me section and click on this highlighted option.
3rd - After clicking this you will get the below output. You can go to edit axis and remove the 60%,80% reference line.
which will result in
4th - Add the profit to the column shelf and dual axis the same. you will get the below output. Change the chart type the way you need.
For profit change the chart type to shapes and put measure names in the the Shape shelf. This will help you to assign shape to profit. Double click on the last highlighted section (at the bottom) and assign star shape.
I hope this helps. You can refer sheet15 or sheet16. There is just a change of measure that I have used.
Thanks and Regards,
Dual axis along with shapes.twbx 378.6 KB
Thank you for the quick answer. It is such a clear and useful instruction. I did complete the graph by your instruction.
1 of 1 people found this helpful
Glad my instructions helped you.
Can you please Mark my response as correct and close the thread? Please refer to the below image where I have highlighted "Correct Answer" button.
Thanks And Regards,