Dotted Line/ Dashed Lines on a Bar Chart

[Gladiator909]

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

[Bubble4502 · Accepted solution]

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]

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?

[Gladiator909]

Thank 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.

[Gladiator909]

The data that I showed is not the real dataset I am working with, just dummy data to convey what I am trying to do. Maybe something like this would make more sense:

Just want the forecasted line to be dashed/dotted in PowerBI

[lbendlin]

Phew!  That makes so much more sense...  Please provide sanitized sample data that fully covers your issue.