cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
meddojeddo
Helper IV
Helper IV

Count of concatenated reason codes for each dimension?

I have a table where there is one column which has a bunch of reason codes concatenated like this "Billing issue - Technical issue - Discount - Value - Customer" and they are not necessarily in the same order and the number of ones listed for each field varies. I am wanting to create a bar chart which is a count of the rows where each of these reason codes occur, for example Billing Issue 241, Technical Issue 154, Discount 103, etc. Is there a way to do this in Power BI? 

1 ACCEPTED SOLUTION

Hi @meddojeddo 

Due to I don't know your data model, I build a sample to have a test.

My Sample:

1.png

In addition to  

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

4 REPLIES 4
RicoZhou
Community Support
Community Support

Hi @meddojeddo 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

 

Best Regards,

Rico Zhou

amitchandak
Super User
Super User

@meddojeddo , Not very clear. Split this power query and then you can count.

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

https://www.youtube.com/watch?v=FyO9Vmhcfag



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!

@amitchandak what I am looking to do is to create a bar chart which shows the count of the occurrence of each of those reason codes(Billing issue, Technical issue, Discount, etc.). In other words, the reason code would be the dimension and the conut of their occurrence would be the measure. However they are contained in a column where for each row there is a series of them split up by a "-" delimiter, like this: "Billing issue - Technical issue - Discount - Value - Customer". Does that make more sense?

Hi @meddojeddo 

Due to I don't know your data model, I build a sample to have a test.

My Sample:

1.png

In addition to  

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors