Forum Discussion
GRedhead
Helper I
Helper IDynamics 365 Multi Select Option Set Filter in Power BI
Hi,
I need help I have a multi-select option set that I have brought into Power BI and want to make a slicer on, but I see the same value in multiple lines.
I want to only see the value once i.e:
Investor
Other
and not
Investor
Investor, Other
Other
Any help is appreciated.
1 Reply
- amitchandak
Super User
GRedhead , If possible, split the column into rows or columns in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
