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.
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êsUser | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |