Forum Discussion
Hide & Show table visual
- Anonymous8 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
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
Thank you Anonymous,
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
- Anonymous8 years agoNot applicable
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
- mehaboob5578 years ago
Resolver III
Thank you.
If this work my purpose. I will accept your solution.
Thank you once again :)
Regards,
Mehbub - (skype Mehaboob57)