Forum Discussion
Helper IDotted Line/ Dashed Lines on a Bar Chart
Hi everyone,
I am trying to make something fairly simple but it does not look like its doable.
I have a bar chart along with a line, the client wants the line to be "dotted" instead of solid. Since the line is supposed to represent foreceast. There does not seem to be a way to do this!
Any ideas?
Here is the data along with the chart:
Column1Column2Column3
| A | 5 | 30 |
| B | 10 | 25 |
| C | 15 | 20 |
| D | 20 | 10 |
| E | 25 | 4 |
Hi Gladiator909 ,
You can change the style of line to Dotted by using format visual:
Output:
Kind Regards,
Bubble
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Bubble4502Resolver III
Hi Gladiator909 ,
You can change the style of line to Dotted by using format visual:
Output:
Kind Regards,
Bubble
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- lbendlin
Super User
Do you mean a column chart? I don't think there is any way to have lines on a standard bar chart. Can you show the expected outcome?
Gladiator909Thank you very much for responding to my question. I basically want the line on the chart above to be dotted. This is what I was able to reproduce within Excel but not in PowerBI:
Any ideas how this can be replicated on PowerBI?
- lbendlin
That is a column chart.
The line makes no sense as there is no relation between the categories. Line charts should only be used with temporal data, or correlated categories. Looks like you want a Pareto instead?
This is where Tableau is better than Power BI - It wouldn't even allow you to attempt this.
