Line Chart Style

[Adore]

Hi, I'm new to Power BI and I know there's still a lot to learn. I'm just doing some basic visual to get used to the tool. I have a line chart with Budget vs Forecast by month. It looks like the first image below. The black line is the budget and the blue line is the actual for the past period and forecast for the future periods. Is there a way to have different line style for actual and forecast, for example, solid line for actual and dash for future forecast, like the second image?

 Bugdet vs Actual

[v-jiascu-msft]

Hi @Adore,

There is a workaround. It seems you have the forecast data in the source table. Maybe you can use two measures for each part. The two measures will join in a dot. Have a look at the sample below.

Measure 16 =
CALCULATE (
    SUM ( FactSales[SalesQuantity] ),
    FILTER ( DimDate, DimDate[Datekey] <= DATE ( 2008, 1, 31 ) )
)

Measure 17 =
CALCULATE (
    SUM ( FactSales[SalesQuantity] ),
    FILTER ( DimDate, DimDate[Datekey] >= DATE ( 2008, 1, 1 ) )
)

Best Regards,

Dale

[vanessafvg]

@Adore under your properties ie. the paintbrush on the right hand side of your pane, look for shapes, you can change the lines there

[Adore]

Thanks. How would I have two different line style for the same series though? I need to have a solid line up to April and dash from May onwards.

[vanessafvg]

@Adore as far as i know you can't do it for the same line, you will have to do two different lines however if they have the same amounts up until the point it becomes a forecast it should be easy to almost look like they are the same line... if that makes sense?