Help wanted for line series visual

Question

My data is like so&nbsp;dept &nbsp; Year &nbsp;&nbsp; percentage &nbsp;a &nbsp; &nbsp; &nbsp; &nbsp; 2013 &nbsp; &nbsp; &nbsp;&nbsp; 99%a &nbsp; &nbsp; &nbsp; &nbsp; 2014 &nbsp; &nbsp; &nbsp;&nbsp; 99%a &nbsp; &nbsp; &nbsp; &nbsp; 2015 &nbsp; &nbsp; &nbsp; 100%b &nbsp; &nbsp; &nbsp; &nbsp; 2013 &nbsp; &nbsp; &nbsp; &nbsp; 60%b &nbsp; &nbsp; &nbsp; &nbsp; 2014 &nbsp; &nbsp; &nbsp; &nbsp; 70%b &nbsp; &nbsp; &nbsp; &nbsp; 2015 &nbsp; &nbsp; &nbsp; &nbsp; 90%It always seems to average the % total I just want the data shown as it is. Any suggestions is it where I am placing my fields, legend, axis, value etc &nbsp;&nbsp;A trend line would also be useful though i'm not sure if Power Bi has this functionality.&nbsp;Any help greatly appreciated

marksl · Answer

Assuming by Line Series Visual that you mean a Line Chart? If so then see below:

I have loaded your data into a table, with the percentages as decimals, eg 99% = 0.99. I have then formatted the column as Percent from the Modelling Ribbon.

Create a Line Chart visual and assign as follows:

Axis = Year

Legend = Dept

Values = Percentages

To add a Trend Line, go to the Analytics tab of the Line Chart and add a Trend Line. Take note of the option 'Combine Series'. If selected, the trend line will sit between your two Departments, as per below, else you will get a trend line per Department:

jay2077 · Answer

That's really helpful thank you.&nbsp; My line chart visual won't allow me to add trendlines am I right in thinking I need another visual ?

marksl · Answer

Hmm, I am using the standard out-of-the-box Line Chart. &nbsp;Have you go the latest version of Power BI Desktop (April 2018)?

jay2077 · Answer

Not sure where do I get that from?

marksl · Answer

Again assuming you are using Power BI Desktop, then it can be found here:&nbsp;https://powerbi.microsoft.com/en-us/desktop/&nbsp;I am pretty sure my Desktop version prompts me to get the latest version when one comes available (each month).&nbsp;You can check which version you are on by going to the Help ribbon and selecting About:&nbsp;

Forum Discussion

Help wanted for line series visual

6 Replies

Related content

Want to apply Conditional Formatting on Matrix Visual

Want to apply Conditional formatting on matrix visual

Month Series

Sorting Visualization Series

Can't change series color in ribbon chart