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

48f8c130 db49-4423-a53b-660a15c8af04 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

c381308e 1701-4448-810f-62c7fd7e67bc 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

30963250 a1c8-4a8f-85c6-c9b3d52d98b4 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

1eb3b72a 47e5-49dc-9a72-10c57ea5e74a 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

0cbab4a7 5958-4c42-9cac-4b6210252f2e 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

94971792 356f-4c77-a815-336dc56ebc8f 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

4a4cfc81 eaa8-4131-be27-6e7b73c0ad75 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

7b947cf9 646f-4965-a5e0-a5bb56d4b592 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

f4c20bc6 c5c4-4289-8987-88f88a60da3a 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

c91dad94 24e5-4389-aee6-4598f9aa6fef on 05 Jul 2020 22:32:51

RE: dotted lines in linecharts

Definitely required, quite surprised this is omitted.