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.
Is there a way to format table rows so that say if the row had "Closed" in the "Office Status" column, the row is "Red", but if the Office Status" is "Open", then then the row is green?
Solved! Go to Solution.
Office_Status_Custom_Column = IF(Sheet1[Office Status] = "Closed", 0, IF(Sheet1[Office Status] = "Open", 1, 2))
Create a custom column to mark the open status as 1 and closed as 0.
Then apply conditional formatting based on rules to set the background color for each of the cols based on the value in the new column
Thanks, not overly familiar with custom columns, so struggling with the code.
Guess it would be something like
Office_Status_Custom_Column = IF(Sheet1[Office Status] = "Closed"), "0"), IF(Sheet1[Office Status] = "Open"), "1"), IF(Sheet1[Office Status] = "Other"), "2")
But cant figure it out, any guidence would be great.
Office_Status_Custom_Column = IF(Sheet1[Office Status] = "Closed", 0, IF(Sheet1[Office Status] = "Open", 1, 2))
Thanks 👍
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |