Calculate Table based on slicer option

[parry2k]

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

[Eric_Zhang · Accepted solution]

---

@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

---

@parry2k

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.