Need Solid and Dotted lines in the same chart

[snemilipuri]

Hi,

We have the below fields 

Dimension: Region ( East, west, North and South)

Measures: 1. Actual

                 2. Target

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:  4 solid (actuals), 4 dotted (target)

Just like below image. Please help

[AshwinKulkarni]

@snemilipuri , 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

[snemilipuri]

Hi Ashwini,

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,  instead of creating multiple measures (individual measures for actual and target) is there any alternative. Please suggest.

[amitchandak]

@snemilipuri , You can not have legends with two measures in a standard like viusal. You need to check for some custom visual

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

[snemilipuri]

Can you please suggest any custom visual suitable for this requirement