Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Word Search Slicer?

Say I have a chart like so:

 ID Description 888 This is BLUE 150 This is dark BLUE 850 This is light GREEN 422 This is RED 397 This is really BLUE 431 This tends to be YELLOW 214 This seems like it's GREEN 272 This is product RED 532 This had the color RED

I need to make a bar chart that will show a count of how many descriptions have the word "BLUE", "GREEN", "RED", "YELLOW". So the count should end up like so: Blue = 3, Green = 2, Red = 3, Yellow = 1

How can I achieve this?

This would be a live feed data so every day it needs to refresh whatever calculation it is making.

1 ACCEPTED SOLUTION
Super User

Ok well her is one example of the way you can solve it.

1. create a table with all your keywords

2 cross join that table to your table you want to search

3 create an if statement that returns the colour value of the description if it contains a keyword

4 remove all other rows.

see example attached.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

6 REPLIES 6
Super User

so must it find any of the words or be an exact match ie you want to know exactly how many are blue or, you want to know how many have any of those colours?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Frequent Visitor

Any description that contains that word, whether it used to be or is lightly that color, should come up in the filter. So I guess I should have added an expected count. It should come up as Blue = 3, Green = 2, Red = 3, Yellow = 1

Super User

and one last question, is this question reflective of your real data or do you have bigger volumes of what you are searching for, and how big is your data?

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Frequent Visitor

Real data has about 30 columns and 4k rows

Super User

Ok well her is one example of the way you can solve it.

1. create a table with all your keywords

2 cross join that table to your table you want to search

3 create an if statement that returns the colour value of the description if it contains a keyword

4 remove all other rows.

see example attached.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!

Frequent Visitor

Thank you! This worked out great.

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors