How to display the count of accurance of text seperated by commas in a column in Power Bi live connection

A S, Irfan Sultan 21

This is a column from a table from live connection

this is what the output i am getting.

Where i am trying to create a chart like this.

what is the perfect way to get this result in analysis service live connection. i cannot edit or split the columns or rows. can some one please help me?

FelixP 86 Reputation points

2020-06-16T17:33:53.627+00:00

Would you be able to expand on why you cannot split the columns in Power BI? I would recommend using Get and `transform in Power Query in Power BI to split the columns by the ‘;” delimiter. https://community.powerbi.com/t5/Desktop/Splitting-multiple-columns-using-delimiter/td-p/438358

This requires Power BI desktop - is this available in your workflow?
KranthiPakala-MSFT 46,492 Reputation points Microsoft Employee

2020-06-18T16:45:54.403+00:00

Hi @A S, Irfan Sultan ,

Just checking to see if you have got a chance to try @FelixP recommendation?

----------

Thanks
KranthiPakala-MSFT 46,492 Reputation points Microsoft Employee

2020-06-22T16:54:38.233+00:00

Hi @A S, Irfan Sultan ,

Just checking to see if you still need assistance on this query. In case if you have found a different solution, please do consider to share it here with community as it would be beneficial to others.

----------

Thank you
A S, Irfan Sultan 21 Reputation points

2020-06-23T07:38:30.93+00:00

Hi @FelixP-2774, i can split the columns but unfortunately the strings in the columns with ";" separator is dynamic. because we do nothave the generic set of responsible organization. for example: today it will be mixture of 5, tomorrow it will be 13 and a day after it may be 3. is their any way to bring those random organizations in the chart without splitting the column. Thanks.

Accepted answer

Anonymous

2020-06-22T17:00:26.533+00:00

Also note; Power Bi is not currently supported here on QnA. They're actively answering question in dedicated forums here.
https://community.powerbi.com/

--please don't forget to Accept as answer if the reply is helpful--

Regards, Dave Patrick ....
Microsoft Certified Professional
Microsoft MVP [Windows Server] Datacenter Management

Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to display the count of accurance of text seperated by commas in a column in Power Bi live connection

0 additional answers

Your answer