Forum Discussion
Unwanted Table Entries Appear During Dashboard Table Selection
Hi,
I have two main tables in the dashboard i select values from: Table 1 and Table 2. When i select a value from Table 1, Table 2 displays a group of entries related to the selected value in Table 1. Then i like to go thru each of the values in the group to display a graph (not shown here), however, when i select the entry in Table 2, it displays the entire Table 2 which i don't want to see. See image below.
Does anyone have an idea on how to keep Table 2 persistent to the 5 entries selected from Table 1 as i select each of the 5 in Table 2?
Thank you...Miguel
2 Replies
- AnkitBI
Solution Sage
Not sure if you are looking for this, however have you tried using CTRL + CLick while selecting values from Table2. It will retain all the 5 values.
https://docs.microsoft.com/en-us/power-bi/desktop-multi-select
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful. - v-easonf-msft
Community Support
Hi , miguelsus2000
According to you description ,maybe you can try the following workarounds:
1)If you can edit the report ,you can try to render the table1 as a slicer, like the following:
2)using ctrl +click (As AnkitBI said )
However,this is just used to select multiple rows for doing some operations.
3)you can also add filtering conditions directly to Table 2 , instead of using Table 1 to interact with Table2 , like the following:
If I misunderstood your problem , please let me know.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.