Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want to color each field with the biggest value green within each row. How can I do this? Without doing it manuelly. I think it has something to do with Conditional formatting?
Solved! Go to Solution.
Hi @jtj
@Uzi2019 @KeyurPatel14 Thank you very much for your prompt reply. Please allow me to share other methods here.
If your source data is in the following format, perform the unpivot operation.
Select Transform data to enter Power Query.
You'll get:
Create a measure.
Measure =
VAR RowMax = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Category] = MAX('Table'[Category])))
RETURN
IF(SELECTEDVALUE('Table'[Value]) = RowMax, "GREEN", "WRITE")
Create a matrix.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jtj
@Uzi2019 @KeyurPatel14 Thank you very much for your prompt reply. Please allow me to share other methods here.
If your source data is in the following format, perform the unpivot operation.
Select Transform data to enter Power Query.
You'll get:
Create a measure.
Measure =
VAR RowMax = CALCULATE(MAX('Table'[Value]), FILTER(ALL('Table'), 'Table'[Category] = MAX('Table'[Category])))
RETURN
IF(SELECTEDVALUE('Table'[Value]) = RowMax, "GREEN", "WRITE")
Create a matrix.
Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It seems like the awnser is to make a matrix instead of a table.
hi @jtj
Please check the below video for better understanding.
https://www.youtube.com/watch?v=m0h3Ghl6mgY
https://www.youtube.com/watch?v=wTRrskQzAHk
https://www.youtube.com/watch?v=FSTiPm5tY8A
I hope above videos would help you to understand the conditional formatting setting for Matrix visual.
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |