Need Solid and Dotted lines in the same chart

Question

Hi,&nbsp;We have the below fields&nbsp;Dimension: Region ( East, west, North and South)Measures: 1. Actual&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2. Target&nbsp;Now the requirement is to create a line chart with Acuals as solid line and Targets as Dotted line.so the output will be 8 lines:&nbsp; 4 solid (actuals), 4 dotted (target)Just like below image.&nbsp;Please help&nbsp;&nbsp;&nbsp;

anonymous · Answer

@snemilipuri&nbsp;, Can you please try to put these values in 8 diferent columns and then try to pull all columns in field region.And do not use anything in legends region.I hope this helps.Thanks,Ashwin Kulkarni&nbsp;

amitchandak · Answer

snemilipuri , You can not have legends with two measures in a standard like viusal. You need to check for some custom visual 
&nbsp;
https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

snemilipuri · Answer

Can you please suggest any custom visual&nbsp;suitable for this requirement

snemilipuri · Answer

Hi Ashwini,&nbsp;This worked, Thanks. But the list of values in the dimension are more than 10 and the list may also increase. So in this case,&nbsp; instead of creating multiple measures (individual measures for actual and target) is there any alternative. Please suggest.

Forum Discussion

Need Solid and Dotted lines in the same chart

4 Replies

Related content

dotted line

Line graph with solid and dotted lines

Single line in line chart with dotted and solid

Line Chart: Solid lines up to certain dates and then Dotted line

How to create a line chart which is both solid and dotted