Hide & Show table visual

[mehaboob557]

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 in table1, the table2 should be hidden. If i select any value in table1 then only other table should display

For Ex:

table 1   (this data is coming from product table)

quoteNO |  version

blr--001       0.1

blr--002       0.2

blr--002       1.0

1) If i click on 1.0 in table1 the below table should display its respected data from another data table. 

table 2   (this data is coming from product-addon table)

ProductName|  product Area| product price |  version | quoteNo

prod-001             100                     101010          1.0          blr--002

prod-002              100                    232323          1.0          blr--002

2) If i click on 0.2  in the table1 the below table should display its respected data from another data table. 

table 2   (this data is coming from product-addon table)

ProductName|  product Area| product price |  version | quoteNo

prod-001             100                     101010          0.2         blr--002

prod-002              100                    232323          0.2          blr--002

I want to know is that possible?

I have just exported  2 tables and bridge table into CSV and updated into new pbix file

you can find it here  

Please suggest me .

[v-shex-msft · Accepted solution]

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

[mehaboob557]

Thank you @v-shex-msft,

If i am creating a table from other table... it will be dynamic?

Because every day the tables will refresh which will fecth the data from MySQL.

So the custom table will also be refreshed with the new values?

Thanks,

Mehbub

[v-shex-msft]

Hi @mehaboob557,

>>So the custom table will also be refreshed with the new values?

Yes, new table just a copy who not contains the relationship to original table. If original source refreshed, it will auto update.

Regards,

XIaoxin Sheng

[mehaboob557]

Thank you.

If this work my purpose. I will accept your solution.

Thank you once again 🙂

Regards,

Mehbub - (skype Mehaboob57)