Forum Discussion
Post ProdigyChange category axis depending on selected value
I have the following tables in a 1:M relationship:
| Project | Vendor | |
| 1 | A | |
| 2 | B | |
| 3 | C | |
| 4 | D | |
| 5 | E |
| Test | Project | Test Name | ||
| 1 | 1 | Test A | ||
| 2 | 1 | Test B | ||
| 3 | 2 | Test A | ||
| 4 | 2 | Test C | ||
| 5 | 3 | Test B | ||
| 6 | 3 | Test D | ||
| 7 | 3 | Test E | ||
| 8 | 4 | Test B | ||
| 9 | 5 | Test A | ||
| 10 | 5 | Test D |
Instead of showing up like this when I click a Vendor value:
Is it possible to make it look like this instead where the categories will change depending on what the user clicks in the dashboard (as opposed to using a slicer):
Hi olimilo
Yes It can be done
Can you please try the below steps to get your result.1. select the vendor table
2. Go to format tab and click on edit interaction.3.
On the clustered column chart, you'll see two icons:
One for highlight (default).
One for filter.
4. Click the Filter icon instead of Highlight.
If this answers your questions, kindly accept it as a solution and give kudos.
1 Reply
- mdaatifraza5556
Super User
Hi olimilo
Yes It can be done
Can you please try the below steps to get your result.1. select the vendor table
2. Go to format tab and click on edit interaction.3.
On the clustered column chart, you'll see two icons:
One for highlight (default).
One for filter.
4. Click the Filter icon instead of Highlight.
If this answers your questions, kindly accept it as a solution and give kudos.