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 ,

 

For your reference take a look at attached screen shot.

In the Category property, you can enter different drill down fields let's Year,Month, Day etc. and in Values property you can put one measure or numeric value.

 

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

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
    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.