cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver IV
Resolver IV

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
Highlighted
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
Resolver IV
Resolver IV

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

 

Highlighted
Community Support
Community Support

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
If this post helps, please consider accept as solution to help other members find it more quickly.
Highlighted
Resolver IV
Resolver IV

Re: Hide & Show table visual

Thank you.

 

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

 

Thank you once again 🙂

 

Regards,

Mehbub - (skype Mehaboob57)

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors