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
OK, I have come to a complete wall with Power BI.
I do't "get" calculated columns.
Here's a data example:
Customer SLA SLA Result (FYI False means not breached)
ACME P1 False
ACME P3 False
ACME P4 True
ACME P4 False
ACME P3 True
ACME P4 False
ACME P1 False
ACME P3 False
ACME P4 True
Gadgets P4 False
Gadgets P3 True
Gadgets P4 False
Etc for several thousand rows.
Note that the SLA Result is ONE column, that is either true or false.
I can easily do a matrix that shows the % of row total but I want to:
a. Eliminate the %xxx.xx forced formatting
Conditionally format so that when a particualr companie's P1 is <80% False that is dispalyed in Red for each company, for each SLA!
So in my example above:
Customer SLA % not Breach
ACME P1 100 (Shouild be Green)
ACME P3 66 (should be red)
ACME P4 80 (should be red)
Gadgets P1 90 (Shouild be Green)
Gadgets P2 100 (Shouild be Green)
Gadgets P4 85 (Orange wouild be nice!
ANY HELP appreciated!
Solved! Go to Solution.
@Anonymous ,
Add measure below and take a look at Color formatting by field value.
Measure = DIVIDE ( COUNTROWS ( FILTER ( Table1, Table1[SLA Result] = FALSE () ) ) + 0, COUNTROWS ( Table1 ) ) * 100
@Anonymous ,
Add measure below and take a look at Color formatting by field value.
Measure = DIVIDE ( COUNTROWS ( FILTER ( Table1, Table1[SLA Result] = FALSE () ) ) + 0, COUNTROWS ( Table1 ) ) * 100
That's awesome,. thanks!
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 |