Forum Discussion

pawelj795's avatar
pawelj795
Post 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
Tahreem24's avatar
Tahreem24
Super 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
Post 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
    Super 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
    Super User
    6 years ago

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

  • pawelj795's avatar
    pawelj795
    Post 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.