Make table blank until filtered by another table

Question

Hi - i have been looking at similar posts where tables are set to be blank until a slicer value has been selected, but I have not found any yet which does a similar thing, but from a table row being selected.

This shows what i have currently (CURRENT), and the effect i am trying to achieve. The two data tables are joined on [ID].

What DAX could i use to achieve this? I tried playing around with IF(CROSSFILTER but not sure this works when selecting a row in a table? Is this possible?

The above image is an example, my real file has too much confidential information to post.

Thanks

amitchandak · Answer

Actually you check is filtered for any of the filter
example
if(isfiltered(Param1[Param1])&nbsp; || isfiltered(Param2[Param2]) , [measure], blank()) //add more as per need&nbsp;
&nbsp;
refer : https://www.youtube.com/watch?v=hXg3kRFSGjA

anonymous · Answer

Hi&nbsp;rogerdea&nbsp;,
&nbsp;
Please check this blog, it should suit your needs.
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/&nbsp;
&nbsp;
Best Regards,
Jay

Forum Discussion

Make table blank until filtered by another table

2 Replies

Related content

Filtered table

FILTER TABLE BASED ON ANOTHER TABLE

Filter table using another table result

Conditionally filtering rows from a table with another table

Filtering Dates from another table