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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Super User
Super User

@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!:
Power BI Cookbook Third Edition (Color)

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.