Skip to main content
Microsoft Idea

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

Bhavesh on 05 Jul 2020 23:22:06

RE: dotted lines in linecharts

Hi It would be really nice to add the dotted line/diffenrent color line for the missing data values. Currently you can show the gaps for the missing days/values but adding this functionality can make power bi really shine.

Check out the best practices suggested by Stephen Few:
https://www.perceptualedge.com/example14.php

Thanks

Terje Fjeldstad's profile image Profile Picture

Amanda Cofsky on 05 Jul 2020 23:01:18

RE: dotted lines in linecharts

For those looking for this feature, we have identified an issue in our October 2017 release of Desktop that is prevent the UI from showing. The fix will be included in the November 2017 release of Desktop. It is a Desktop only bug, so in the meantime, as a workaround you can edit your reports in the web to add your line styles. Thanks for reporting it and your patience while we resolve the issue.

Terje Fjeldstad's profile image Profile Picture

Mike Honey on 05 Jul 2020 23:01:07

RE: dotted lines in linecharts

I'm seeing the same thing in the October 2017 update - the Visualizations pane, Shapes section is back to only showing Stroke width and Join type. All the new properties have been removed.

Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:01:06

RE: dotted lines in linecharts

This feature has been removed in October 2017 update.Can we please get this feature back?

Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:00:50

RE: dotted lines in linecharts

Was this feature removed for October 2017 update?

Terje Fjeldstad's profile image Profile Picture

Jack Wells on 05 Jul 2020 22:58:15

RE: dotted lines in linecharts

Can this functionality be added to the line and bar charts as well?

Terje Fjeldstad's profile image Profile Picture

Josiah Raiche on 05 Jul 2020 22:57:06

RE: dotted lines in linecharts

I believe this was delivered in the August update

Terje Fjeldstad's profile image Profile Picture

Sam Johnson on 05 Jul 2020 22:49:42

RE: dotted lines in linecharts

Agree with the comments above, charting functionality should at the very least replicate what I can do in Excel. This is also fairly standard functionality in Spotfire as well, would definitely help with adoption in my organization. Thanks!

Terje Fjeldstad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:49:38

RE: dotted lines in linecharts

Really need this for our internal use. The Engineers are building their own charts in excel and it is causing a whole lot of consistency issues.

Terje Fjeldstad's profile image Profile Picture

Robert Ogden on 05 Jul 2020 22:42:05

RE: dotted lines in linecharts

Anyone that creates charts would be interested in this Industry-Standard functionality. Currently, with no ability to change line-type or bar/column fill, there are very few options to accomodate users with visual impairments such as Color-Blindness, which is a significant cross-section of our company's report consumers. If you have multiple lines on a chart, you can't even make one thicker than the other in order to differentiate. It's either 'all or nothing'.

The incredible lack of standard reporting options that are missing from Power BI is very frustrating and incredibly surprising.