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
Hello Community,
My dataset Resume : Player# | Label| Value
Label can be "TOPS", "Competition", "Management", "Training"
Value is the value of the Label
I want to show a colour based on the value and the Label
ColumnColour =
VAR ValueCompet = CALCULATE(MAX('Resume'[Value]), 'Resume'[Label] = "Competition")
VAR ValueTrain = CALCULATE(MAX('Resume'[Value]), 'Resume'[Label] = "Training")
VAR RLabel = 'Resume'[Label]
VAR RValue = 'Resume'[Value]
RETURN
SWITCH(
TRUE(),
RLabel = "Management",
SWITCH(
TRUE(),
RValue >= 150, "Green",
RValue >= 90, "Yellow",
TRUE(), "Red"
),
RLabel = "TOPS"
SWITCH(
TRUE(),
ValueTrain < ValueCompet, "Green",
ValueTrain = ValueCompet, "Yellow",
TRUE(), "Red"
)
)
The issue lies with the last label "TOPS", where it consistently displays "Yellow" for all players. When the label is "TOPS", it only considers the value of "TOPS" instead of taking into account the comparison between `ValueEntr` and `ValueCompet`.
After several attempts, I focused solely on the condition where Label equals TOP.
ColumnColour =
IF(Resume[Label] = "TOPS", CALCULATE(MAX(Resume[Value]), FILTER(Resume, Resume[Label] = "Training")))
and the result is blank.
The idea is how to display the value of "Training" where Label = TOPS. This is the root problem that's why the comparison doesn't work.
How can this be rectified?
Thank you
Solved! Go to Solution.
You are my Savior JamesFR06 Thank you so much
Merci beaucoup 😍
HI,
Just add allexcept after your max calculations
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 |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
59 | |
20 | |
12 | |
11 | |
10 |