Forum Discussion
How to Exclude all data showing on Table2 when UnSelect on Table1
Goal: only show data in Table2 once a selection is made from Table1
In the screenshot below, Table2 shows details of Canada selection from Table1. If I unselect from Table1, I don't want anything to load in Table2.
This is similar to the exclude all values action in Tableau
https://www.youtube.com/watch?v=Vy7EyCtKRDQ
Why: Table2 has too much details and takes too long to load
Method: Using the sample financials data that comes with Power Bi Desktop
Hey VinhTon ,
unfortunately, this is not possible, as it's not possible to display a visual based on a condition.
Maybe, you can try to create a measure used in table2 like so:if( hasonevalue( 'table'[country] ) , calculate( sum( 'table'[Sales] ) ) , blank() )A different approach is to place table2 on a different report page, that only can be accessed by using conditional navigation: Create a drillthrough button in Power BI - Power BI | Microsoft Docs
Hopefully, this provides some ideas on how to tackle your challenge.Regards,
Tom
2 Replies
Hey VinhTon ,
unfortunately, this is not possible, as it's not possible to display a visual based on a condition.
Maybe, you can try to create a measure used in table2 like so:if( hasonevalue( 'table'[country] ) , calculate( sum( 'table'[Sales] ) ) , blank() )A different approach is to place table2 on a different report page, that only can be accessed by using conditional navigation: Create a drillthrough button in Power BI - Power BI | Microsoft Docs
Hopefully, this provides some ideas on how to tackle your challenge.Regards,
Tom
Thanks for confirming this is not possible. Spent all yesterday looking
