How can I set a same summary chart for multiple fields

[kkalyanrr]

Hello Team,

Is there a way I can set up a summary chart to work on 2/more different fields based on slicer selection..

I was thinking of having a same slicer with 2 values country and appliance and if I select country then I should be able to get the summary of prices.

Please help.

I/P Table :::

Country	Aplliance	Price
US	AC	500
US	CAMERA	700
CAN	LAPTOP	400
CAN	AC	500
IN	LAPTOP	700
IN	CAMERA	500

O/P Tables:::::

Country	Price
US	1200
CAN	900
IN	1200

Appliance	Price
AC	1000
CAMERA	1200
LAPTOP	1100

Thanks,

Kalyan..

[v-yulgu-msft]

Hi @kkalyanrr,

Please first unpivot your input table in Query Editor mode.

Select [Country] and [Aplliance] columns at the same time, then, click unpivot column button. 

Rename columns with meaningful names.

In report view, add [Country & Aplliance] into slicer, add [Category] into axis area of chart.

Best regards,

Yuliana Gu

[kkalyanrr]

Hello @v-yulgu-msft

Thanks for the reply,  Unpivoting creates more rows(this case 2 columns and 6 rows resulting 12 rows all together)..I'm working with large datasets, so is there any other solution apart from Unpivoting.

[v-yulgu-msft · Accepted solution]

Hi @kkalyanrr,

Please refer to the solution in this thread.

Best regards,
Yuliana Gu