Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @meddojeddo
Due to I don't know your data model, I build a sample to have a test.
My Sample:
In addition to amitchandak 's reply ,try split column by "-" to row.
Build a bar chart:
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.
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
@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
@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:
In addition to amitchandak 's reply ,try split column by "-" to row.
Build a bar chart:
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |