Forum Discussion
Background Color manually
Hey, man taylororiger
I did test it again, I tried to recreate something that you have and used the exact same formula:Measure = SWITCH(TRUE(), ISBLANK(MAX('PE Relationship Detail'[Engagement Quality Reviewer Name]))&&MAX('PE Relationship Detail'[PE total fees])>500000,"yellow")
Applied to all columns and it works, the only thing that can be wrong is that make sure your blanks are actually blank, notice that in Power Query, blanks are "null". This won't appear in the Visual layer, however, make sure you can see it like that in power query:You can replace it like this:
if you don't want to test and debug anything, you can add something like to your formula that checks either blank or empty string:
Measure = SWITCH(TRUE(), (ISBLANK(MAX('PE Relationship Detail'[Engagement Quality Reviewer Name])) || MAX('PE Relationship Detail'[Engagement Quality Reviewer Name])="")&&MAX('PE Relationship Detail'[PE total fees])>500000,"yellow")This should work even when you don't have your blank rows actually blank.
So try this new formula first and lemme know.
I don't see an error. Do you have it Table Visual?
Can you write similar data but with not confidential data and paste her, something that would serve same purpose but with no specific data?
What is table visual?
I would but I am not sure how to do that! This is all very new to me
Hi, taylororiger
this me trying to recreate your issue with using exact same Measure:I used conditional formatting for both columns and when conditions are met, the rows are yellow.
I would also suggest trying some Youtube videos on how to work with Power BI as it probably saves you way more time than waiting for people to answer your questions:
Here for basics:
https://www.youtube.com/watch?v=TmhQCQr_DCA
Here for Conditional Formatting:
https://www.youtube.com/watch?v=VyOyKkjWeU0Thank you! I do know how to apply conditional formatting and I have it applied across all of the columns. I think the issue is the measure isn't reading correctly, and I am not sure how to write that or adjust it.
I have crossed off qualifying information to visualize my data and also to view the measure in the screenshot below.
Does this look correct?
Below is the conditional formatting I have applied to every column;
It looks like everything matches your instructions so I ma not sure what went wrong? No rows are colored.
Hey, man taylororiger
I did test it again, I tried to recreate something that you have and used the exact same formula:Measure = SWITCH(TRUE(), ISBLANK(MAX('PE Relationship Detail'[Engagement Quality Reviewer Name]))&&MAX('PE Relationship Detail'[PE total fees])>500000,"yellow")
Applied to all columns and it works, the only thing that can be wrong is that make sure your blanks are actually blank, notice that in Power Query, blanks are "null". This won't appear in the Visual layer, however, make sure you can see it like that in power query:You can replace it like this:
if you don't want to test and debug anything, you can add something like to your formula that checks either blank or empty string:
Measure = SWITCH(TRUE(), (ISBLANK(MAX('PE Relationship Detail'[Engagement Quality Reviewer Name])) || MAX('PE Relationship Detail'[Engagement Quality Reviewer Name])="")&&MAX('PE Relationship Detail'[PE total fees])>500000,"yellow")This should work even when you don't have your blank rows actually blank.
So try this new formula first and lemme know.That was the issue!!! Thank you!
taylororiger
Oh boi,
I am glad it is finally working, if you could kudo my answer and accept it as the solution I would really appreciate that.
ThanksHi! I am trying to d a similar measure, however, I am not able to apply the measure to conitional formatting?
Any thoughts?