stacked column and independent line chart

[bass184]

Hello,

New to Power BI, and am trying to recreate in Power BI a stacked column and independent line chart. Structure of excel file is

Month   Data    Type

1             20         1

2             30         1

2              15        2

1              15        Budget

2              45        Budget

Type 1 and 2 would be stacked and budget would be independent line.  Is this possible?

[Domantas]

I have an opposite issue. I know how to make this Line and stacked column chart in Power BI. But how to recreate the same thing in Excel's PivotChart when data is comming from a data model and not from a single table.

https://community.powerbi.com/t5/Desktop/Line-and-Stacked-column-chart-Recreate-in-Power-Pivot/m-p/7...

[v-cherch-msft · Accepted solution]

Hi @bass184 

You may use Line and stacked column chart. Then create two measures and use them in the visual like below:

Type1,2 = CALCULATE(SUM('Table'[Data]),FILTER('Table','Table'[Type] in {"1","2"}))

BudgetLine = CALCULATE(SUM('Table'[Data]),FILTER('Table','Table'[Type]="Budget"))

Regards,