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 !
I have a table where the column "%" is a measure that is the percentage of incidentes that have met the target (Met/Count). There is different target number for each priority, for example: Critical is 95%, High is 90%...
The problem is that I can't do conditional formatting for different targets, green if greater and red if smaller. Is thare any way to do this?
Thanks in advance for any help.
Solved! Go to Solution.
Hi @luizronsani ,
You can create a measure to make the formatting based on the % and the Priority something similar to the one below:
Condittional Formatting =
SWITCH (
TRUE ();
(
SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
&& [%] >= 0,95
); "#75FF00";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
&& [%] < 0,95
); "#E66C37";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "High"
&& [%] >= 0,90
); "#75FF00";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "High"
&& [%] < 0,90
); "#E66C37"
)
You just need to two lines for each of the priority and change the colours on the formaating to the ones you need, then use the field value on the conditional formatting..
Check the result attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @luizronsani ,
You can create a measure to make the formatting based on the % and the Priority something similar to the one below:
Condittional Formatting =
SWITCH (
TRUE ();
(
SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
&& [%] >= 0,95
); "#75FF00";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "Critical"
&& [%] < 0,95
); "#E66C37";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "High"
&& [%] >= 0,90
); "#75FF00";
(
SELECTEDVALUE ( 'Table'[Priority] ) = "High"
&& [%] < 0,90
); "#E66C37"
)
You just need to two lines for each of the priority and change the colours on the formaating to the ones you need, then use the field value on the conditional formatting..
Check the result attach.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |