Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

unpivoted columns and summarization



I've unpivoted two columns, to get a list of products and how many of each are available.

Now I would like to make a line chart, that summarizes the number of each product, however, 

I can only make a count of how many incidents of the product (if product is available two different stores eg. 4 in one and 2 in another, it shows 2).


Anyone know how I can do this?

Community Support
Community Support

Re: unpivoted columns and summarization

Hi @BiBra,


Please share some dummy data and clarify the expected results so we can test it. 


Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper III
Helper III

Re: unpivoted columns and summarization

Like this:


product            available

pc                          2

tv                           3

pc                          5


When I try to make the chart, I want the graph to show there are 7 pc's.

However I only get to make count of incidents. Therefore it shows 2.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors