cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mehaboob557 Member
Member

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 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 .

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Hide & Show table visual

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:

 13.PNG

 

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
4 REPLIES 4
Community Support Team
Community Support Team

Re: Hide & Show table visual

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:

 13.PNG

 

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mehaboob557 Member
Member

Re: Hide & Show table visual

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

 

Community Support Team
Community Support Team

Re: Hide & Show table visual

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mehaboob557 Member
Member

Re: Hide & Show table visual

Thank you.

 

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

 

Thank you once again Smiley Happy

 

Regards,

Mehbub - (skype Mehaboob57)