Forum Discussion

kkalyanrr's avatar
kkalyanrr
Icon for Helper V rankHelper 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 applian...
Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi kkalyanrr,

     

    Please refer to the solution in this thread.

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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
    Icon for Helper V rankHelper 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.

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

      Hi kkalyanrr,

       

      Please refer to the solution in this thread.

       

      Best regards,
      Yuliana Gu