Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a Data table that looks like in the picture below. I have one column with unique IDs and one column with a text string. The text string contains different combinations of a code. I want to be able to filter the table based on if one (or several) of the codes contains in the text string.
I have manually created new conditional columns for each code.
Is there a way to have a simple “filter table” connected to the Data Table and filter the Data Table with this filter table? How do I do this?
Grateful for help!
Solved! Go to Solution.
@Anonymous , if you have only the first two columns. My advice would split the second column into rows in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
@Anonymous , if you have only the first two columns. My advice would split the second column into rows in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
Thank you so much! That works perfectly!
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |