Forum Discussion
Calculate Table based on slicer option
hi there,
Need help. I have a table 1 with 2 values
- option 1
- option 2
Another table 2 with following values
- slicer 1
- slicer 2
- slicer 3
I have slicer from table 1, I want to show 2nd slicer from table 2 if "option 2" selected from table 1. Not sure if i need to calculate table or how I can achieve this, look forward for some solution
Thanks in advance!
P
parry2k wrote:
hi there,
Need help. I have a table 1 with 2 values
- option 1
- option 2
Another table 2 with following values
- slicer 1
- slicer 2
- slicer 3
I have slicer from table 1, I want to show 2nd slicer from table 2 if "option 2" selected from table 1. Not sure if i need to calculate table or how I can achieve this, look forward for some solution
Thanks in advance!
P
Those two tables shall be in a proper relationship if you'd like the interaction described. Either via a calculated column or a calculated middle table.
1 Reply
- Eric_Zhang
Microsoft Employee
parry2k wrote:
hi there,
Need help. I have a table 1 with 2 values
- option 1
- option 2
Another table 2 with following values
- slicer 1
- slicer 2
- slicer 3
I have slicer from table 1, I want to show 2nd slicer from table 2 if "option 2" selected from table 1. Not sure if i need to calculate table or how I can achieve this, look forward for some solution
Thanks in advance!
P
Those two tables shall be in a proper relationship if you'd like the interaction described. Either via a calculated column or a calculated middle table.