Display Table Visual When Something is Selected in Another Table Visual

[h_l]

Hello,

Is it possible keeping Table2 as blank (display nothing) until anything is selected in Table1?

A Measure is applied in Table1, the Measure cannot be applied to Slicer or breakdown by other Column. So the only way I can image is to let user select somthing in Table1, then list selected items and their breakdown in Table2.

Thanks in advance.

H

[v-yalanwu-msft · Accepted solution]

Hi @h_l ,
Through your description, I tried an example and create flag measure by the following formula:

flag = IF(ISFILTERED('Table 2'[ID]),1,0)

Then apply it into table2’s visual filter:

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[h_l]

Thank you!

[Nathaniel_C]

Hi @h_l , you could use a bookmark and a button perhaps with a measure ALLSELECTED.  The bookmark would show a blank visual until something is selected, and then show the table 2. Not sure if this is what you are looking to do.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[h_l]

Hi @Nathaniel_C , sounds like a workaround.

But would you mind to introduce more detail steps...

I am still new to PBI, what I know is how to create a bookmark to "reset" everything on page, about what you recommended, bookmark work with Measure, have little idea.

Thank you.