Forum Discussion
Post PatronOnly showing data in a second table when a single row is selected in first table
I have a list of contacts who attended events. I can see a table of the most recent event they attended.
Each contact can be a part of one or more office. Offices are shown in a second table.
I only want to show the offices in the second table, when a single contact ( or row in the first table) is selected.
As i have no measures on the tables and am not aggregating, im unsure how to tackle this.
The below link is to a sample pbix illustrating the issue, . I want to only see the offices in the Contacts Office table, when a user selects a single contct row in the attendance table.
Appreciate any advice on this.
4 Replies
- vanessafvg
Community Champion
wilson_smyth if i click a row in the table with contact name it shows only the office selected, so dont understand what your issue is exactly? maybe screen shot and show the problem
wilson_smythApologies, I did not ask the question correctly.
Currently, if no rows are selected, all offices are displayed in the offices table.
I want 0 rows to show in the offices table, unless a row is selected in the contacts & events table.
GazzerResolver II
I don't believe what you want is currently possible.
Maybe it would be worth suggesting as an update?
I would vote for the idea...
- v-jiascu-msft
Microsoft Employee
Hi wilson_smyth,
There could be a workaround. But I can't do it in your mode. It's something like this: adding a tag column.
tag = IF ( ISFILTERED ( Office[Office Name] ), COUNT ( Contact[Contactname] ), BLANK () )Please create an idea here for the new feature.
Best Regards,
Dale
