Forum Discussion

mehaboob557's avatar
mehaboob557
Icon for Resolver III rankResolver III
8 years ago
Solved

Hide & Show table visual

Hi All,   I need small help from you.  Suppose i have filters , then multiple tables below. If i wanna show another table based on some click how can i achieve that. If i am not selecting anything ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI mehaboob557,

     

    It is impossible to use table 1 as filter to expand table 2 columns.


    For your requirement, you need to:
    1. Use the filter effect to get select value from table 1.
    2. Break the interaction between table 1 and table 2 to expand table2 records who has the similar version.

     

    If filter effect still alive, table 2 records will be filtered by chosen of table 1. (expand records will be ignored)
    If you break the relationships/interaction between table 1 and table 2, it is impossible to get table 1 selected items at table 2 side.

     

    In my opinion, you can create a copy from product table to achieve your requirement.

    Steps:

    1. Create new table based on product table and use new table to build visual.

    Table formula:

    Table = product_data

    2. Write measure to get selected value from new table, then compare table 2 row contents with above value to return tag.

      Measure:

    Tag = 
    IF (
        MAX ( addon_data[version] ) IN ALLSELECTED ( 'Table'[version] )
            && MAX ( addon_data[quoteNo] ) IN ALLSELECTED ( 'Table'[quoteNo] ),
        1,
        0
    )

    3. Drag tag measrue to table 2 visual level filter. 

     

    Result:

     

     

    Notice: new table not have relationships to table1 and table2.

     

    Regards,

    Xiaoxin Sheng