Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Im trying to apply logic into matrix but based on different rule for almost each cell in a row.
I'm using currently only one measure to give me percentage result.
What i have so far:
What the result of formatting should look like:
Appreciate your help, Dan 🙂
Solved! Go to Solution.
Hi @Daniel_Derbin,
For this you need to create a metric similar to this:
Formating =
SWITCH (
TRUE (),
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Critical"
&& [% of vuln wo Sev] >= 0.92, "Green",
SELECTEDVALUE ( Table[Record age] ) = "31-60 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Critical"
&& [% of vuln wo Sev] <= 0.08
&& [% of vuln wo Sev] > 0, "Yellow",
(
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
|| SELECTEDVALUE ( Table[Record age] ) = "31-61 days"
)
&& SELECTEDVALUE ( Table[Severity] ) = "High"
&& [% of vuln wo Sev] >= 0.95, "Green",
SELECTEDVALUE ( Table[Record age] ) = "61-90 days"
&& SELECTEDVALUE ( Table[Severity] ) = "High"
&& [% of vuln wo Sev] <= 0.05
&& [% of vuln wo Sev] > 0, "Yellow",
(
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
|| SELECTEDVALUE ( Table[Record age] ) = "31-61 days"
|| SELECTEDVALUE ( Table[Record age] ) = "61-90 days"
)
&& SELECTEDVALUE ( Table[Severity] ) = "Medium"
&& [% of vuln wo Sev] >= 0.95, "Green",
SELECTEDVALUE ( Table[Record age] ) = "91-180 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Medium"
&& [% of vuln wo Sev] <= 0.05
&& [% of vuln wo Sev] > 0, "Yellow",
(
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
|| SELECTEDVALUE ( Table[Record age] ) = "31-61 days"
|| SELECTEDVALUE ( Table[Record age] ) = "61-90 days"
|| SELECTEDVALUE ( Table[Record age] ) = "91-180 days"
)
&& SELECTEDVALUE ( Table[Severity] ) = "Low"
&& [% of vuln wo Sev] >= 0.95, "Green",
SELECTEDVALUE ( Table[Record age] ) = "180-360 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Low"
&& [% of vuln wo Sev] <= 0.05
&& [% of vuln wo Sev] > 0, "Yellow",
"Red"
)
This may need some adjustments, there is also an option to create a table with the values of your maximum and minimun values if you want I can try and setup that table that would allow you to give you a better editing option in the future.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Daniel_Derbin,
For this you need to create a metric similar to this:
Formating =
SWITCH (
TRUE (),
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Critical"
&& [% of vuln wo Sev] >= 0.92, "Green",
SELECTEDVALUE ( Table[Record age] ) = "31-60 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Critical"
&& [% of vuln wo Sev] <= 0.08
&& [% of vuln wo Sev] > 0, "Yellow",
(
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
|| SELECTEDVALUE ( Table[Record age] ) = "31-61 days"
)
&& SELECTEDVALUE ( Table[Severity] ) = "High"
&& [% of vuln wo Sev] >= 0.95, "Green",
SELECTEDVALUE ( Table[Record age] ) = "61-90 days"
&& SELECTEDVALUE ( Table[Severity] ) = "High"
&& [% of vuln wo Sev] <= 0.05
&& [% of vuln wo Sev] > 0, "Yellow",
(
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
|| SELECTEDVALUE ( Table[Record age] ) = "31-61 days"
|| SELECTEDVALUE ( Table[Record age] ) = "61-90 days"
)
&& SELECTEDVALUE ( Table[Severity] ) = "Medium"
&& [% of vuln wo Sev] >= 0.95, "Green",
SELECTEDVALUE ( Table[Record age] ) = "91-180 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Medium"
&& [% of vuln wo Sev] <= 0.05
&& [% of vuln wo Sev] > 0, "Yellow",
(
SELECTEDVALUE ( Table[Record age] ) = "0-30 days"
|| SELECTEDVALUE ( Table[Record age] ) = "31-61 days"
|| SELECTEDVALUE ( Table[Record age] ) = "61-90 days"
|| SELECTEDVALUE ( Table[Record age] ) = "91-180 days"
)
&& SELECTEDVALUE ( Table[Severity] ) = "Low"
&& [% of vuln wo Sev] >= 0.95, "Green",
SELECTEDVALUE ( Table[Record age] ) = "180-360 days"
&& SELECTEDVALUE ( Table[Severity] ) = "Low"
&& [% of vuln wo Sev] <= 0.05
&& [% of vuln wo Sev] > 0, "Yellow",
"Red"
)
This may need some adjustments, there is also an option to create a table with the values of your maximum and minimun values if you want I can try and setup that table that would allow you to give you a better editing option in the future.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi MFelix,
That worked as a charm after smal adjustments.
Thank you a lot!! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |