Forum Discussion

kkalyanrr's avatar
kkalyanrr
Icon for Helper V rankHelper V
8 years ago

Summary Table with able to slice to sub sections using slicers

Hello,

 

I'm using a dataset simmilar to the below one


and I'm using one pie chart with Category and Price combination

and second chart is summary chart with Category and Price combination..

Now the problem is when I click on portion of pie chart, the summary chart has to be summerized based on the pie chart proportion (Lets say if I select Portion QWE in the first chart, then summary chart to be limited to portion QWE ).

 

I tried using the following formula

 

SUMX (
VALUES ( Table1[Slicer] ),
IF (
CALCULATE ( COUNTROWS ( Table1 ) ) >= 1,
CALCULATE ( SUM(Table1[Price] ) )
) , blank())

 

Thanks Lot.. 

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi kkalyanrr,

     

     

    Not so sure for your requirement, can you please share more detail? If this chart means the matrix visual, you can direct click on donut chart to filter this visual. 

     

    BTW, slicer only works on measure and visual, it is impossible to effect calculate column/table by slicer.

     

    Regards,

    Xiaoxin Sheng

    • kkalyanrr's avatar
      kkalyanrr
      Icon for Helper V rankHelper V
      8 years ago

      Thanks for the reply Anonymous ..

       

      When we select QWE in the Donut chart, the summary table(Matrix) gives us the info about only QWE... simple table QWE-250

       

      My requirement is , when I click on QWE portion of the pie chart, the  summary chart should be able to give summary based on second slicer's input.

       

      Hope I'm clear now..

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        HI kkalyanrr,

         

        I don't think power bi can support to dynamic modify the summary column based on other visual.

         

        Regards,

        Xiaoxin Sheng