Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
Is it possible to apply conditional formatting based on (value in card is equal to or less than or greater than measure value)
Example: "Measure" value is dyanmic (usually 1-100)
card value = achievement of agent
Expected outcome: if achivement of agent is less than "Measure" value then the background of the value should be RED
Below was achieved using conditional formatting in excel with ()
Need in power bi matrix visual
Solved! Go to Solution.
hi, @iknowganesh
follow below step
make mesure for outcome
go to formatting measure > select conditional formatting > select background color
select feild value
press ok
you get these
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos.
Hi @Dangar332,
Below is what we achieved in Excel:
Agent Name | Closed Points | formula here | Outcome | Target assumed | 500 | ||
A | 120 | =(B2/500)*31/DAY(TODAY()) | 1.06 | days in month | 31 | ||
B | 80 | =(B3/500)*31/DAY(TODAY()) | 0.70 | today value | 7 | 07/10/2023 | |
C | 49 | =(B4/500)*31/DAY(TODAY()) | 0.434 | ||||
D | 102 | =(B5/500)*31/DAY(TODAY()) | 0.9 | ||||
Conditional formatting rules based on value | |||||||
outcome< | 0.5 | Red | Stop if true | ||||
outcome< | 0.7 | Yellow | Stop if true | ||||
outcome< | 0.9 | Orange | Stop if true | ||||
outcome< | 1 | Light Green | Stop if true | ||||
outcome> | 1.2 | Green | Stop if true | ||||
hi, @iknowganesh
follow below step
make mesure for outcome
go to formatting measure > select conditional formatting > select background color
select feild value
press ok
you get these
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly. Appreciate your kudos.
hi, @iknowganesh
select your matrix visual got to visuals formatting apne and select cell element and enble background color like below
select fx it open conditional formatting pane here change format style to rule , and what field should we base this on select your your column using your table name.
and put your rules in condition like below
after these your matrix look like
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @Dangar332
Thank you for your response. I tried the option you provided & it works well for static rule.
However, in our scenario, this rule values needs to be changed everyday as the target for the day changes as **Target = 100/31 days multiplied by today***.
Please advise a best way to achieve this 🙂
Kudos
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |