Forum Discussion
Calculating text number in strings
Hello guys,
I need help in one topic. I have 37 different type programs. This programs located in System IT columns like that.
1. CMS (HR-42449)
2. ElmaBpm (HR-42448) ElmaDF (HR-70432) Optimus (HR-1343451)
3. Zeus (HR-42446) CMS (HR-42449)
4. ElmaBpm (HR-42448) Zeus (HR-42446)
5..
6..
I want to see that I have 2 CMS (HR-42449), 2 ElmaBpm (HR-42448), 2 Zeus (HR-42446), 1 Optimus (HR-1343451), 1 ElmaDF (HR-70432) values in my column.
Then I want to create line chart and want to show all values in my line chart. I have 37 different group like that.
This Column is part of my Dashboard table and name is System IT.
Also, I want to this column depends on my different columns.
2 Replies
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi,
Somewhere, do you have a list of all 37 programs (which are spelled exactly the same way as they are spelled in your dataset)? If yes, then share that list and your dataset (in a format that can be pasted in an MS Excel file).
