Forum Discussion
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 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
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.
4 Replies
v-yalanwu-msftCommunity Support
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
Community Champion
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.
NathanielHi 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.
