How to Visualize SUMPRODUCT Value Using Bar Chart

Anonymous — Tue, 27 Oct 2020 17:27:04 GMT

Hi, I'm new in power BI. I had problem to visualize my data using bar chart with the value using sumproduct value. My goal is to create chart like this

Using below data:

Size	Thickness	Type	Date	Company	TONS	USD	USD/TONS
5	10	A	1-Jan-20	X	10	1000	100
5	20	B	5-Feb-20	X	20	3000	150
5	10	A	1-Jan-20	Y	10	1000	100
5	20	B	5-Feb-20	Y	20	3000	150
10	10	A	18-Jan-20	X	10	2000	200
10	10	A	18-Jan-20	Y	10	4000	400
10	20	B	28-Mar-20	X	20	2000	100
10	20	B	28-Mar-20	Y	20	4000	200
10	30	C	30-May-20	X	20	6000	300
10	30	C	30-May-20	Y	20	4000	200
1	10	A	9-Apr-20	X	20	10000	500
1	10	A	9-Apr-20	Y	20	20000	1000

My only concern is how to put the value in chart using SUMPRODUCT value on above data on the USD/TONS.

Thank you,

Regards,

Danang

Re: How to Visualize SUMPRODUCT Value Using Bar Chart

lbendlin — Sat, 07 Nov 2020 01:42:59 GMT

which values are you trying to multiply? Your sample data doesn't match the chart, so it is difficult to see that.

Re: How to Visualize SUMPRODUCT Value Using Bar Chart

Anonymous — Mon, 09 Nov 2020 02:26:27 GMT

Hi @lbendlin ,

I need to show the USD/TONS value (USD divided by TONS) for each TYPE.

Thanks!

topic Re: How to Visualize SUMPRODUCT Value Using Bar Chart in Custom Visuals Development Discussion

How to Visualize SUMPRODUCT Value Using Bar Chart

Re: How to Visualize SUMPRODUCT Value Using Bar Chart

Re: How to Visualize SUMPRODUCT Value Using Bar Chart