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 Reputation points

This is a column from a table from live connection 10150-sc-table-1.jpg

this is what the output i am getting. 10184-sc-table-two.jpg

Where i am trying to create a chart like this. 10115-sc-output.jpg

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?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
{count} votes

Accepted answer
  1. Anonymous

    Also note; Power Bi is not currently supported here on QnA. They're actively answering question in dedicated forums here.

    --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.

    0 comments No comments

0 additional answers

Sort by: Most helpful