Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Table visual Interaction based on the Pie Chart slice selection

Hi Experts, I want to showcase the table visual data based on the pie chart slice selection. I have a table already with below data with different columns (cost,scope,schedule etc..) , taking "scop...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous ,

I did not encounter your problem in my testing.
Both account names are displayed when green is selected for the pie chart.

 

The data table is shown below.


Please see the attached pbix for reference.

Best Regards,
Dengliang Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Anonymous  thanks for your solution 🙂

    I noticed that you have used "scope logic" as a values in pie chart instead of "scope combined" , so that the table is not reflecting the both account (different color icons) , but is there any chance to change the color icons in the table visual based on the pie chart selection ? because both accounts are visible when we click "Green" but from the stalkholders/clients side they cannot identify it directly ..
    thanks for understanding 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Anonymous  any lead pls ?

    I am using scope logic as a calculated column created based on some logics , but your side you have just created a new column with name of the colors ..

     

    When i am using the same logic as of you ..

    I am getting this result because of the table having unpivot column applied.

     

    If i choose count(distinct) :