Forum Discussion

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago
Solved

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

     

     

     


    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.

     

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Icon for Microsoft Employee rankMicrosoft 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

     

     

     


    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.