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.
Hi,
Need help with conditional formatting. I have a table with activities and statuses (closed/open). So I added this measure (called Measure) but it gives value 2 to blank cells as well:
Solved! Go to Solution.
Hi, @Alex_0201
According to your description, I think you can create a measure, It only judge the two states of open and closed.
like this:
Measure = IF(MAX('Table'[Status])="open","Red",IF(MAX('Table'[Status])="closed","Green"))//Omit blank()
Then use it in condifitional formatting.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi, @Alex_0201
According to your description, I think you can create a measure, It only judge the two states of open and closed.
like this:
Measure = IF(MAX('Table'[Status])="open","Red",IF(MAX('Table'[Status])="closed","Green"))//Omit blank()
Then use it in condifitional formatting.
Like this:
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
@Alex_0201 , Blank cell can not be colored
Try this
color measure =
var _1 = coalesce(MAX([Table]), "Closed")
return
SWITCH(_1,
"Closed","Green"
"Open","Red"
)
Use this in conditional formatting using field value option
)
@amitchandak, thanks! but I need this measure as an input in conditional formatting for background color of cells thus the values 1 and 2. And with your modification I can not choose the measure in conditional formatting anymore.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |