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.
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):
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.
Thank you a lot.
Solved! Go to Solution.
I have manage this by this video:
@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?
@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 query | search results | package viewed | doctor count |
ranexa | ranexa 10g ranexa 20g ranexa 30g | ranexa 20g | 1 |
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 query | search results | doctor 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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |