Forum Discussion
Combining
Hi Community,
I have a table :
Unique ID with combination of name given to it.
I want to filter by unique name , that will show all ID it is given. One ID can appear twice in the name allocated to it.
I have attached the file.
For instance :
"a " is present in ID 1, 3, 4, 6, 7, 9, 10
"b" is present in ID 1, 2, 3, 4, 5, 7, 8, 10
Here ID 10 appears in "a" and "b"
When user filters "a", show all ID it belongs to
When user filters "b", show all ID it belongs to
Thanks in advance
schoden , I think better is you split by delimiter into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Find the file attached after signature
2 Replies
- amitchandakSuper User
schoden , I think better is you split by delimiter into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Find the file attached after signature
- schodenPost Partisan
Thank you amitchandak I didnt realise we can split into rows....I did by Columns and Got more Confused>
Thank You