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.
I am trying to assign a backgroud color to certain rows in my table. However, the background color relies on 2 different criteria instead of 1, so I don't think I am able to achieve this in the conditional formatting route. Is there a way to manually select rows to have a background color?
Solved! Go to Solution.
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.
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.
Thanks
Hi! I am trying to d a similar measure, however, I am not able to apply the measure to conitional formatting?
Any thoughts?
Thank 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.
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |