Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
213 | |
124 | |
117 | |
81 | |
75 |