Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display Table Visual When Something is Selected in Another Table Visual

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 break...
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    Hi Anonymous ,
    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.

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous , 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.