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.
Hey guys, I've got the following table that I got using Switch function. Now basically I want to do condition formatting for the last two rows(percentages) but only for them, that if they are above 0% then green otherwise red. The problem is, that I can only put formatting on two measures, which is the two colums that I got right now. So if I use it, the whole column goes green, but I only need to the last two rows.
this is my switch function :
Solved! Go to Solution.
@Anonymous
Try the following.
Create a conditional formatting measure along the lines of:
Conditional Format Values =
IF(SELECTEDVALUE('Table'[Type]) IN {“2020 FAKTAS”, “2019 FAKTAS”, “2020 PLANAS”}, "black",
IF(AND(SELECTEDVALUE('Table'[Type]) IN {“POKYTIS NUO 2020 PLANO”}, [Pokytis nuo 2020 plano per mèn] >0), "Green",
IF(AND(SELECTEDVALUE('Table'[Type]) IN {“POKYTIS NUO 2019 FAKTO”}, [Pokytis nuo 2019 fakto per mèn] >0), "Green", "Red")))
The use this measure in the formatting pane under "Conditional Formatting", select the field and select the font colour option and use the [Conditional Format Values] measure (the yellow highlight should be the measure you are using in the visual):
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
Try the following.
Create a conditional formatting measure along the lines of:
Conditional Format Values =
IF(SELECTEDVALUE('Table'[Type]) IN {“2020 FAKTAS”, “2019 FAKTAS”, “2020 PLANAS”}, "black",
IF(AND(SELECTEDVALUE('Table'[Type]) IN {“POKYTIS NUO 2020 PLANO”}, [Pokytis nuo 2020 plano per mèn] >0), "Green",
IF(AND(SELECTEDVALUE('Table'[Type]) IN {“POKYTIS NUO 2019 FAKTO”}, [Pokytis nuo 2019 fakto per mèn] >0), "Green", "Red")))
The use this measure in the formatting pane under "Conditional Formatting", select the field and select the font colour option and use the [Conditional Format Values] measure (the yellow highlight should be the measure you are using in the visual):
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
For conditional formatting you have to use separate switch function
Switch(true(),condition1,"Red",Condition2,"RGB(0,255,0)","Light Blue") and use the Field value option to take that on the field using conditional formatting! Hope this clarifies!
Proud to be a Super User!
@Anonymous Share the formula you have used for conditional formatting
Proud to be a Super User!
User | Count |
---|---|
85 | |
74 | |
71 | |
68 | |
56 |
User | Count |
---|---|
96 | |
94 | |
92 | |
78 | |
71 |