Forum Discussion
Conditional Format Based on Two Columns
I've been searching the community for how to handle this but not been successful with what I've found so far. I'm trying to update conditional formatting so that if the stage is Initiate or Plan and Implementation Dates, Funding Dates, Cost Plan, and Budget Plan are "N" then the background color is blank but if they're "Y" the background color is green. Any suggestions?
Hi
You can create a flag measure with a combined condition with "and"
And base a conditional formatting on this measure.
For more detailed suggestionPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523As I mentioned it is a scenario to combine measure if you will attach data I will try to show how it can work 🙂
Hi kp_wood13
If i understood correctly you can use Dax measure like :Flag for formatting =if ((max('Table'[stage]) = "initiate" || max('Table'[stage]) = "Plan") && max('Table'[Value])= "N", "red",if (MAX('Table'[Value])= "Y", "green"))and use it in the conditional formatting of the matrix:Result:
you can use hex color codes instead of their names if you want other green/red
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickl
For what it's worth I found a solution in this post. Rather than just looking at the two stages I'm making rules for all 4.
7 Replies
For what it's worth I found a solution in this post. Rather than just looking at the two stages I'm making rules for all 4.
Hi
You can create a flag measure with a combined condition with "and"
And base a conditional formatting on this measure.
For more detailed suggestionPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Ok basically in English I'm looking for:
IF 'Query1'[stage]="Initiate" || 'Query1'[stage]="Plan" && 'Query2'[impl_dates]="N" || 'Query2'[funding_dates]="N" || 'Query2'[cost_plan]="N" || 'Query2'[budget_plan]="N" THEN "BLANK" ELSE "GREEN"
As I mentioned it is a scenario to combine measure if you will attach data I will try to show how it can work 🙂
Here's a sample table based on my 'Query1' table. Background colors didn't copy in but basically any "N" in the first two rows should have no background color because [stage]=Initiate or Plan, but the bottom two rows they'd be Red. "Y" is green regardless of the stage listed.
stage prj_description impl_dates impact_entities funding_dates cost_plan budget_plan Initiate N Y N Y N Y Plan Y N Y N Y N Execute N Y N Y N Y Close Y N Y N Y N