How to combine solid and dotted line from two different columns in one line plot

[adrianortuno]

I have a time series with several columns that have gaps in the data, these gaps are filled in separate calculated columns. I'd like to plot a graph with several lines that are connected across with dotted lines where the data is missing. 

Already wronte the DAX function to calculate the filled columns, trying to figure out the plot. Thanks in advance.

[Anonymous · Accepted solution]

Hi @adrianortuno ,

You can follow these steps to restore the view you expect:

(1)  Use custom visuals. Find the right app | Microsoft AppSource

(2) We can create two calculated column.

A_Column = IF('Table'[A]=BLANK(),'Table'[A_f],'Table'[A])

B_Column = IF('Table'[B]=BLANK(),'Table'[B_f],'Table'[B])

(3) Change the line format of [Value2] and [Value4] to [Dash] and then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[amitchandak]

@adrianortuno , Check some custom visual, I doubt that with standard visual

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

One option is Charticulator 

Charticulator Part 1 - Bar and Bar Matrix: https://youtu.be/tKgG0arMaOw