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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
gduobaite
Helper III
Helper III

Color the rows

Hello, 

 

I have a matrix with typed search query (first column), what results appeared (second column) and what was clicked from the search (third column):

gduobaite_1-1600346561623.png

 

 

Is it possible to color only that row in a second column which was selected from the third column? I mean if row from "Search results" = row from "Packages viewed", then row in a second column turns into green. That would mean that colored info (rows) was clicked during the search. I have found some info that it will need two columns with color (1; green) and somehow relate it to my needs. Or not.

 

gduobaite_0-1600346449074.png

 

Thank you a lot.

1 ACCEPTED SOLUTION

3 REPLIES 3
Greg_Deckler
Community Champion
Community Champion

@gduobaite I'm note entirely clear on this requirement. I do not understand why the highlighted rows should be green. Can you post some sample data as text, expected results and why?

 

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler, trying to explain. 

Rows in second column that are the same as in third column, should be green in the second column. That would mean, that client selected and viewed only that one row from the entire search. Or if package was not viewed, client was selected non of them, just looked on the search results and gone away. 

 

I have a simple data:

search querysearch resultspackage vieweddoctor count
ranexa

ranexa 10g

ranexa 20g

ranexa 30g

ranexa 20g1
xarelto

xarelto 10g

xarelto 20g

xarelto 30g

no package viewed

1

 

hello

hello 1

hello 2

hello 3 

hello 3

1

 

And my expected results (background in green, not text):

 

search querysearch resultsdoctor count
ranexa

ranexa 10g

ranexa 20g

ranexa 30g

1
xarelto

xarelto 10g

xarelto 20g

xarelto 30g

1
hello

hello 1

hello 2

hello 3

1

I have manage this by this video:

https://www.youtube.com/watch?v=FgnPIaxpdJ0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors