I'm hoping to recreate a graph similar to the below in power bi? It was created in excel by adding 'markers' to the line graph and removing the actual line.
anyone able to help?
Solved! Go to Solution.
I Believe, you are using Line and Stacked Column Chart.
1. Go to Chart Format options, Go to Data color then Select the Color to white (Hiding the line)
2. Now, just below , there is a section called Shapes, Just Select Show Marker. That's it.
I can't see a 'show marker' option under shapes...
Also, in some cases, the line goes over the columns, so you can see the white ... there's no way to turn the line off completely?
Ignore that, i released my x axis had to be on 'categorical'!
Ideally i can change the line to transperant, but I'm not sure there's an option for that...
Thanks for your help!
I am actually having the same issue to solve. Changing line color to white does not help as it actually is white and if that overlaps with columns, then you can see white lines.
This does not solve my problem. I am not trying to modify the look of the legend but I want to show a value using columns and another using markers only.
How can I do it?