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 Community,
Is it possible to see in a column like below The 3 best and the 3 worst with.
Thank you
Solved! Go to Solution.
Hi @Milozebre ,
Try to do like this:
1. creating a calculated column:
Rank =
RANKX(
'Sheet1 (2)',
[quantity],
, ASC, Dense
)
2. creating a measure:
Color =
VAR x =
CALCULATE(
MAX([Rank]),
ALL('Sheet1 (2)')
)
RETURN
IF(
MAX([Rank]) >= 1 && MAX([Rank]) <= 3,
"red",
IF(
MAX([Rank]) <= x && MAX([Rank]) >= x-2,
"green"
)
)
3. adding the measure to "Conditional formatting->Background color":
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Milozebre ,
Try to do like this:
1. creating a calculated column:
Rank =
RANKX(
'Sheet1 (2)',
[quantity],
, ASC, Dense
)
2. creating a measure:
Color =
VAR x =
CALCULATE(
MAX([Rank]),
ALL('Sheet1 (2)')
)
RETURN
IF(
MAX([Rank]) >= 1 && MAX([Rank]) <= 3,
"red",
IF(
MAX([Rank]) <= x && MAX([Rank]) >= x-2,
"green"
)
)
3. adding the measure to "Conditional formatting->Background color":
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hil @v-lionel-msft ,
Thank you very much for your reply.
Its perhaps a stupid question but what's "sheet1 (2)"
Hello @luapdoniv ,
Thank you for the reply.
I want to see the same view like that.
If not, only the highlighted 🙂
Thnak you in advance
This is the closest I could get.
Highlight top 3 values by conditional format as background color and highlight bottom 3 values by conditional format as font color
OR
Highlight top 3 values by conditional format as background color and highlight bottom 3 Names by conditional format as background color
Will continue R&D to see if your requirement can be achieved. Let me know if this helps.
This is the closest I could get:
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |