Forum Discussion

Adore's avatar
Adore
Regular Visitor
8 years ago

Line Chart Style

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 firs...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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 ) )
)

Line_Chart_Style

 

Best Regards,

Dale