Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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 |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
104 | |
69 | |
48 | |
41 | |
34 |
User | Count |
---|---|
164 | |
111 | |
62 | |
53 | |
38 |