Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
175 | |
147 | |
134 | |
105 | |
82 |