10 Apr’18

BIPowerBI April 2018 Update: Combo Chart Line Formatting

Introduction:

PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, these features were not applicable to lines in combination charts like ‘Line and Stacked Column Chart’ and ‘Line and Clustered Column Chart’.

With the April update of PowerBI Desktop, we are now able to customise the format for lines in combo charts to different styles, which then reflect in the legend, making the chart easier to read and understand.

Steps:

  1. While using a combo chart, all line series are in the ‘Solid’ format with just the defined colours differentiating them and the legend only displays their respective colours as shown below.
  2. To format the line or line series, go to the ‘Format’ pane and under the ‘Shapes’ card, you will find several options to customise the format of the lines.
  3. Shade Area can be switched On to shade the area each line encompasses.
  4. ‘Stroke Width’ allows you to adjust the thickness of all the lines.
  5. ‘Line Style’ allows you to select whether the line will be displayed as a solid line, dashed or dotted line as shown below.
  6. The next option is ‘Show marker’, which when switched On allows you to select the Marker shape, size and colour.
  7. To customise each line in a series individually, switch On ‘Customize series’. You will get a dropdown to select from the line values and options to customise the format of each line based on the line value selected from the dropdown.
  8. Coming to the customisation of the legend, you can do so by going to the ‘Legend’ card under the ‘Format’ pane. In the Style option, you have three options in the dropdown menu –
    Markers only: This will display only the respective markers in the legend.

    Line and markers: This will display both the respective lines and markers in the legend.

    Line only: This will display only the respective line style in the legend (shown below).

Conclusion:

As we can see, the new April update allows us to completely customise the lines in a combo chart, which not only add more visual appeal but also enables the user to easily read and understand the chart and the data it represents.

Written by

Simran Monteiro

Software Engineer

2 thoughts on “PowerBI April 2018 Update: Combo Chart Line Formatting”

    1. Hello Ala,

      Currently, PowerBI does not have a feature to facilitate this scenario, the minimum Stroke Width is 1 and there is no option for Line Style as ‘None’.

      This feature has been requested ( Link: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31386688-line-combo-chart-with-markers-only-no-visible-lin) and will hopefully be available in future updates.

      However, as a workaround, you could change the Line Style under the ‘Shapes’ card to Dotted, reduce Stroke Width to 1 and change the corresponding data color under the ‘Data Colors’ card to White. This will not make the line disappear but it will reduce its visibility as much as is currently possible.

      I hope this helps! Kindly let me know if you have any other issues.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Reading more then 10K records in D3FOE OData API

    11 July’ 2018

    Introduction: We all know Dynamics 365 Finance and Operations has limitation of 10K records to be fetched at a time usi...

    Read more
  • Paging in D365 Customer Engagement v9.0

    10 July’ 2018

    Introduction: The Xrm.retrieveMultipleRecords method is used to retrieve a collection of records in Dynamics 365 Custom...

    Read more
  • Set up Dynamics 365 connection in Microsoft Social Engagement

    10 July’ 2018

    Introduction: This blog explains how to Set up Dynamics 365 connection in Microsoft Social Engagement. Steps to be follo...

    Read more
  • Voice of the Customer failed to install

    10 July’ 2018

    Introduction: Many people face issues in installing Voice of Customer solution on v9 environment and trying repeatedly ...

    Read more
  • Scribe Insight AX as a Web Service Find Block issue

    10 July’ 2018

    Introduction: If we need to look up for any value from AX then we do it by using a Find Block in Scribe Insight Eg: Basi...

    Read more

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close