Forum Discussion
get value count by seperated comma
Hi team,
I have a csv file uploaded to powerBI, values in C_DS are comma seperated.
I want to get the value count occured in C_DS columns and create a bar or pie chart, expected result are:
Can any expert help advise?
Thanks,
Cherie
11 Replies
- amitchandak
Super User
Anonymous , On of the way split column by delimiter option in power query and split it into rows and then you can have the count at visual level
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
amitchandak how to split it into rows?
Samarth_18Community Champion
Hi Anonymous ,
You can follow below steps to achieve this:
1. Go to edit query and select C_DS then split column as shown below:-
2. Now click on close and apply
3.Now you can use C_DS column & value as count
Thanks,
Samarth
Syndicate_AdminAdministrator
there @Syndicate_Admin ,
can you help translate below 2 into English? I finish split columns, but don't understand how to do bullet2 and bullet3.
*******
2. Now click close and apply
3.You can now use C_DS column and value as a count
*******
amitchandak I know how to split it into rows now, but i meet another issue. there're two more columns contains multi-value(seperated by comma as well). when I applied your solution to all the multi-value columns(split column first and convert to rows), I found that all the stats goes wrong.
Can you help suggest a DAX script that can get the calcuate directly without transforming data?
Thanks,
Cherie- ALLUREAN
Solution Sage
Hi, Anonymous
Is that the result you want to achieve?
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
