Forum Discussion
Recognizing comma separated values individually for charts
Hi gravanoc ,
You can refer the method in the following link to get it:
Match Multiple Values (Comma Delimited) Power BI
Power BI : Split Comma Separated Values into Filter List
If the above one is not your expected result, please provide more raw data in your table MP921000 (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi gravanoc ,
You can refer the method in the following link to get it:
Match Multiple Values (Comma Delimited) Power BI
Power BI : Split Comma Separated Values into Filter List
If the above one is not your expected result, please provide more raw data in your table MP921000 (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
I am facing a similar problem, althoough I understand the above solution works well but how to tackle if the same data has a fourth column that has some revenue or dollar values. In that case it is going to double the revenue numbers.
Please assist