Forum Discussion

kkalyanrr's avatar
kkalyanrr
Helper V
8 years ago
Solved

How can I set a same summary chart for multiple fields

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 :::

 

CountryAplliancePrice
USAC500
USCAMERA700
CANLAPTOP400
CANAC500
INLAPTOP700
INCAMERA500

 

 

O/P Tables:::::

 

CountryPrice
US1200
CAN900
IN1200

 

AppliancePrice
AC1000
CAMERA1200
LAPTOP1100

 

 

Thanks,

Kalyan..

 

 

Need Help
Tips and Tricks

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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's avatar
      kkalyanrr
      Helper V
      8 years ago

      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.