Forum Discussion
dealing with column which has mulitple values
hi guys i am facing a problem in powerbi see me data when i use slicer in powerbi it shows me the excat values under cars field see below actually i ...
Hello! In Power Query you are going to want to split by delimeter, then unpivot other columns. This way you wind up with a table that looks like this:
Instead of this:
With it in the new format, you can have your slicer do what you wanted:
If I click Mazda, we can see jean and john appear.
god bless you it works with me
audreygerred
Super User
Super UserYou are very welcome! Happy to help!