How to get filtered value of an item as line chart which is absent from column chart in combined chart in Power BI

0 votes

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:

enter image description here

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.

enter image description here

Initially, the chart looks as follows: enter image description here

But using the combined chart feature, I select product E as the line chart and get the required chart: enter image description here

I am trying to do something similar in Power BI. enter image description here

I also created a new measure E_sales:

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? enter image description here

Feb 14, 2023 in Others by narikkadan
• 63,720 points
753 views

1 answer to this question.

0 votes

By making a new measure that didn't include product E and using it for column values instead of the measure that only includes E values for line values, I was able to fix the issue.

ProductExceptE = calculate(sum(Sheet1[Sales]), filter(sheet1, Sheet1[Product]<>"E"))

enter image description here

answered Feb 14, 2023 by Kithuzzz
• 38,020 points

Related Questions In Others

0 votes
1 answer

Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

answered Nov 11, 2022 in Others by narikkadan
• 63,720 points
1,352 views
0 votes
1 answer

How to trick an Excel function that wants a column as input to accept a list of values as if these were in a column

Use VSTACK: vstack to make an array: Use it as value ...READ MORE

answered Mar 18, 2023 in Others by narikkadan
• 63,720 points
437 views
+1 vote
1 answer

Between cyber security and CCNA profession which one is best in terms of time to become an expert and salary payment

CCNA professional is more inclined towards the ...READ MORE

answered Dec 18, 2019 in Others by Pri
1,996 views
0 votes
1 answer

How to find out if an item is present in an std::vector?

The most straightforward solution is to count the total number of elements in the vector that have the specified value.  If the count is greater than zero, we've found our element.  This is simple to accomplish with the std::count function. #include <iostream> #include <vector> #include <algorithm> int main() { ...READ MORE

answered May 27, 2022 in Others by Damon
• 4,960 points
13,774 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
3,540 views
0 votes
1 answer

Convert column in excel date format (DDDDD.tttt) to datetime using pandas

Given # s = df['date'] s 0 ...READ MORE

answered Oct 2, 2022 in Others by narikkadan
• 63,720 points
3,386 views
0 votes
1 answer

Excel Pie-Chart in categories

create a pivot pie chart. You can manually ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 63,720 points
1,070 views
0 votes
1 answer

How to freeze the top row and the first column using XlsxWriter?

You can use worksheet.freeze_panes() to achieve this . There ...READ MORE

answered Oct 11, 2022 in Others by narikkadan
• 63,720 points
2,235 views
0 votes
1 answer

How to make an error flagging array in VBA and translate all array elements as a string message?

In my opinion, using an array in ...READ MORE

answered Mar 17, 2023 in Others by Kithuzzz
• 38,020 points
489 views
0 votes
1 answer

Excel formula to get certain cell if the value is between 2 numbers

So, first with vlookup(): A formula so you ...READ MORE

answered Feb 11, 2023 in Others by Kithuzzz
• 38,020 points
1,006 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP