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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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?

 

 


@ 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!:
The Definitive Guide to Power Query (M)

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.