Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
the column has comma separated text i.e. paul, robert, sarah...
In my table visual, I would like to have one row per separated comma i.e
data
------
paul
robert
sarah
how can I do this please? may be in DAX?
Thank you
Solved! Go to Solution.
Use Power Query editor.
Split the column (using comma as delimiter).
Unpivot the columns that have names in them.
Use Power Query editor.
Split the column (using comma as delimiter).
Unpivot the columns that have names in them.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |