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

Tahreem24 
That's my pie chart.

I need only measures in values, nothing more.
Problem is, that I cannot figure out how somehow change interactions between table and chart, because pie chart contains only measures.

pawelj795's avatar
pawelj795
Post Prodigy
6 years ago

Tahreem24 

To sum up, I think that only solution are bookmarks.
But how to create them in approachable way?

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    pawelj795 ,

     

    You can unpivot your different bucket and create pie chart accordingly. GIve me some moments I am posting deets on it.

     

    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 ,

     

    Here you go.

    Step 1: My sample data is look like below:

    Step 2: Select your different bucket like I have selected in below screen shot. And then click on Unpivot Column.

    Step 3: Then you'll get two column Attribute and Values.

    Step 4: Then create a pie chart like below:

     

    Finally, You'll get your expected output. Cause creating bookmark is tedious.

     

     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 
    Unfortunately, your idea are not gonna work.
    You see, for valid calculation of aging I have very complicated measures -> it's not possible to change this.

    In your solution you are using columns.
    That's the main problem.