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

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.