Forum Discussion
Filter all items based on a selection on a visual
marlonip, the funniest thing happened. I came across your question last week and thought about it a bit back then but couldn't think of an approriate answer for you. But just now, it came to mind and I had to test it out and it works!
I used the following test dataset:
RequestID Destination Value 1 Turkey 1 1 Singapore 2 1 Germany 3 2 Belgium 4 2 Turkey 5 2 Singapore 6 Now, don't mind the Value column, we are interested in the RequestID and Destination. I loaded the above in PBI and changed the data category of the Destination column to 'Country'. Then I duplicated the table by creating a calculated table like this:
Table_Copy = Table_OrigIt is a one on one copy of the original table. Then, I created a many-to-many relationship like this:
Now I created a MAP visual based on Table_Orig and a TABLE visual based on Table_Copy. When I select Belgium in the MAP, I want to see everything of RequestID=2 in the TABLE. If I select Germany, I want to see RequestID=1 and if I select Turkey or Singapore I want to see everything, and that works! 😄 (I am happy because I was bumped out I wasn't able to figure it out in the first place while the answer is not as complicated as I initially thought it would be).
Nothing selected, the Table shows everythingGermany selected, table only shows RequestID=1
See my PBIX here: https://1drv.ms/u/s!Ancq8HFZYL_aiIgd8_NWbpeOz2QvWw?e=SdfUgB
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Hi v-joesh-msft.
Here's my pbix file: https://drive.google.com/open?id=1f-nUq5Sj-Xh9l32TThmL0Pf4cVEehmMG
If you have any doubts (my model is in portuguese), please, feel free to reach out to me.
Thank you very much!
marlonip, the funniest thing happened. I came across your question last week and thought about it a bit back then but couldn't think of an approriate answer for you. But just now, it came to mind and I had to test it out and it works!
I used the following test dataset:
| RequestID | Destination | Value |
| 1 | Turkey | 1 |
| 1 | Singapore | 2 |
| 1 | Germany | 3 |
| 2 | Belgium | 4 |
| 2 | Turkey | 5 |
| 2 | Singapore | 6 |
Now, don't mind the Value column, we are interested in the RequestID and Destination. I loaded the above in PBI and changed the data category of the Destination column to 'Country'. Then I duplicated the table by creating a calculated table like this:
Table_Copy = Table_Orig
It is a one on one copy of the original table. Then, I created a many-to-many relationship like this:
Now I created a MAP visual based on Table_Orig and a TABLE visual based on Table_Copy. When I select Belgium in the MAP, I want to see everything of RequestID=2 in the TABLE. If I select Germany, I want to see RequestID=1 and if I select Turkey or Singapore I want to see everything, and that works! 😄 (I am happy because I was bumped out I wasn't able to figure it out in the first place while the answer is not as complicated as I initially thought it would be).
Nothing selected, the Table shows everythingGermany selected, table only shows RequestID=1
See my PBIX here: https://1drv.ms/u/s!Ancq8HFZYL_aiIgd8_NWbpeOz2QvWw?e=SdfUgB
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
JarroVGIT, you're a life saver! Thank you very much! I had to make a few adjustments on my model, but your suggestion was my point of start for the solution based on my data.
The only problem, though, is related to our local report server, which is compatible only with updates until September 19 and doesn't have many-to-many relationships available, so now I'm trying to adapt the fully working PBI to the earlier version to be able to publish for others to see the dashboard, but this is an issue for another thread.
Once again, thank you very much!