Hello
I am trying to formulate an condutional formating, so that if the data falls between the range, it highlights the cell
Intended result
Powerbi
Below is the % of total points and it compares with table above to highlight where the score falls. As 38 < 40 it will hightlight as >25%. Both are different tables and i tried to formulate the following formula with if and it dosent work
Solved! Go to Solution.
Hi,
After some test, i found your logic about [Point(%)], as below column shows:
Points(%) = DIVIDE('Table'[Weighted(Part1)],DIVIDE('Table'[Max(Part1)],'Table'[Actual],0),0)
Then please try this column in Level table:
Part1 =
IF (
SUM ( 'Table'[Points(%)] ) > 'Level'[%SCORE],
IF (
'Level'[%SCORE]
= CALCULATE (
MAX ( 'Level'[%SCORE] ),
FILTER ( 'Level', 'Level'[%SCORE] < SUM ( 'Table'[Points(%)] ) )
),
"←"
)
)
Try this measure:
Color = IF(MAX('Level'[Part1])<>BLANK(),"#FF0000")
Apply this measure to the [Part1], the result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
Hi,
After some test, i found your logic about [Point(%)], as below column shows:
Points(%) = DIVIDE('Table'[Weighted(Part1)],DIVIDE('Table'[Max(Part1)],'Table'[Actual],0),0)
Then please try this column in Level table:
Part1 =
IF (
SUM ( 'Table'[Points(%)] ) > 'Level'[%SCORE],
IF (
'Level'[%SCORE]
= CALCULATE (
MAX ( 'Level'[%SCORE] ),
FILTER ( 'Level', 'Level'[%SCORE] < SUM ( 'Table'[Points(%)] ) )
),
"←"
)
)
Try this measure:
Color = IF(MAX('Level'[Part1])<>BLANK(),"#FF0000")
Apply this measure to the [Part1], the result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto
I am not following this. Is this just a question about the total row? And only conditional formatting the total row? You know where to find the Conditional Formatting options, correct? Sorry, could you clarify?
Hello @Greg_Deckler
Apologies for not explaning better
The table below is based on the calculation. The final result is the total of %points(Approx 38%, highlighted in red).
Now i need to compare this score with the table above to see which value range it falls. 20%<38%<40%, so it will fall in the range of 20%. Both are 2 different tables.
I tried to formulate with IF but it dosent work. I used "←" if condition is true, and "<blank>" if false
Regards
Bishnu
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!
User | Count |
---|---|
27 | |
23 | |
20 | |
16 | |
8 |
User | Count |
---|---|
32 | |
25 | |
18 | |
16 | |
14 |