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.
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!
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 |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |