Skip to main content

Power BI

Completed

dotted lines in linecharts

Vote (283) Share
Terje Fjeldstad's profile image

Terje Fjeldstad on 27 Jan 2015 17:53:06

I would be Nice to have option for setting dotted or solid lines for each rowset in a linechart. typically used for illustrating Budget/forecasts (dotted) and actuals (solid)

Administrator on 29 Aug 2017 07:53:08

You can do this as of our August update of the Power BI Desktop! Check out the details in our blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2017-feature-summary/#lineStyles

Comments (34)
Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:42:04

RE: dotted lines in linecharts

The same line choices that we have in Excel would be a great start - no line and change the marker type - very usefull for when presenting a budget/actual line chart.

Terje Fjeldstad's profile image Profile Picture

Jaikrit Sinha on 05 Jul 2020 22:41:30

RE: dotted lines in linecharts

This is a necessary feature. In order for me to show my clients what the previous year average was (dotted) in comparison to the current year (solid) I need this feature. Please roll it out asap!

Terje Fjeldstad's profile image Profile Picture

Michael Winslett on 05 Jul 2020 22:39:55

RE: dotted lines in linecharts

Without this feature, we will be forced to use a different product to meet our business reporting requirements. In addition to being able to have dotted lines, we also need to be able to have the same line begin as solid and then transition to dotted based on future dates to show actual/projected values.

Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:39:14

RE: dotted lines in linecharts

I agree with this. The ability to show symbols (i.e.: dot) instead of a line, like you can in Excel, would be very beneficial as well.

Terje Fjeldstad's profile image Profile Picture

Heidi on 05 Jul 2020 22:38:47

RE: dotted lines in linecharts

The same line choices that we have in Excel would be a great start.

Terje Fjeldstad's profile image Profile Picture

Roger on 05 Jul 2020 22:38:15

RE: dotted lines in linecharts

Yes. Solid lines for data series with 2 year date range and dashed for those with a1 year range.

Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:47

RE: dotted lines in linecharts

It was the first question I was asked when presenting a budget/actual line chart. I add my vote to the list

Terje Fjeldstad's profile image Profile Picture

Astrid on 05 Jul 2020 22:34:40

RE: dotted lines in linecharts

'having more control over data labels within line charts would also be very helpful.
- being able to have different text colors for each line. when all data labels are the same color, and lines are close together it's hard to tell which label relates to which lines.
- also more control over positioning. right now it looks random, which labels above, below and on the same line.

Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:34:25

RE: dotted lines in linecharts

Heck yes! Needed it this week.

Terje Fjeldstad's profile image Profile Picture

Adam on 05 Jul 2020 22:32:51

RE: dotted lines in linecharts

Definitely required, quite surprised this is omitted.