Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |