I have a pivot table dataset with sales values for A, B, C, D, and E for the years 2030 and 2050. It looks like this:
I want to get a combined chart showing A, B, C, and D as columns. And E as a line. I select Year as the axis, Product as a legend, and Sum of sales as series to get the pivot chart.
Initially, the chart looks as follows:
But using the combined chart feature, I select product E as the line chart and get the required chart:
I am trying to do something similar in Power BI.
I also created a new measure
E_sales = Calculate(sum(sheet1[sales]), filter(sheet1, Sheet1[Product]="E"))
However, I want to remove E from the column chart. And when I filter out E from the column chart, the line for E also gets removed. How can I fix this such that I have only A, B, C, and D as columns and E as a line chart similar to what I have in Excel above?