cancel
Showing results 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

New Member

## Summarize text columns with conditional formatting

Hi

So I have a text column that will have the following values one of the following values(green, red, yellow) per row.  I'd like to see if I can summarize that data as follows.

Algorithmically here what I'd like to do(say our sample is of 5 rows), not sure if this is possible with PowerBi.

1) Find the frequencies of the words in that column

2) If there is a clear max on the word counts (ie. Green shows up 3 times) then the measure should just show "Green" as text; maybe even color the text green.  If instead, Red shows up 3 times then "RED" would be the result, and likewise with Yellow.

3)If there is a no clear max on the word counts(2 Red, 2 Green, 1 Yellow) we show YELLOW for summary.

If possible how would I generalize this so numbers of rows don't matter?  The values for that column will always be those 3(Green, Red, Yellow)

Help

First find the frequencies of the green, red and yellow values.  Say for this same its 5 rows and 3 of the values are Green, then I want to show that the summary of this 5 columns is Green.    Say instead the Red Values are 3 then I want to

Community Support

For your requirements 1,2, I can get the results as expected.

Create a calculated column

`count = CALCULATE(COUNT(Table1[color]),ALLEXCEPT(Table1,Table1[color]))`

Measures

```max = CALCULATE( MAX([count]),ALL(Table1))

final text = CALCULATE(MAX([color]),FILTER(ALL(Table1),[count]=[max]))```

Then edit conditional formatting

Best Regards

Maggie

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.