Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Pie chart - filter Table

Hi, I have Pie chart and table as below. I want to filter my table by every piece of pie chart. My problem is that pie chart contains only measures -> that cannot be change. I think t...
Need Help
Tips and Tricks
Tutorial Requests
pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
6 years ago

Icey 
Tahreem24 

It's working exactly like your description 

 

Now, my question is, how to edit interactions in Advanced Donut Chart between visuals to work somehow like bookmark ?

I want to switching main table by clicking one piece of my pie chart.
For example, I click on 0-15 on pie chart, the table with index number shows only indexes with 0-15 aging etc.

It results with 5 almost same tables only differs for different measures.

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

pawelj795 ,

 

You want something like below:

 

Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

  • pawelj795's avatar
    pawelj795
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Tahreem24 

    Exactly!
    Maybe it's not important, but small adjustment that the same index cannot appear in two different Aging categories.

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    pawelj795 ,

     

    Simple follow my Post for unpivoting the all bucket columns then Take Table and Pie chart and it will automatically interacting with each other.

     

     

    Please don't forget to hit THUMBS UP and Accept this as a solution if it helps you!

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    6 years ago

    pawelj795  Give Thumbs up for Support And mark it as a solution.

  • pawelj795's avatar
    pawelj795
    Icon for Post Prodigy rankPost Prodigy
    6 years ago

    Tahreem24 
    Your solution with unpivoting columns are not gonna work.
    You have every tape of aging group in columns, I have this calculation include in measure. 

    That's why I think that I need bookmarks.
    Only I want to know, if it possible to make every piece of pie chart (or any other visual) to be button to switch between tables.