Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Conditional Formatting - more than one condition from a different table

Hello everyone,

Beginning Power BI user, first time poster and all around nice guy here...

 

I read this thread:
https://community.fabric.microsoft.com/t5/Desktop/Conditional-formatting-based-on-another-table/m-p/942131

 

And I noted vivran22's response that had this example in it:

My question is can these measures have multiple conditions for them?

I have a table that I'd like to use to highlight a field but there are FOUR fields that all have to match for the field to highlight. 

 

Due to HIPAA policies, I'm unable to share any files so I apologize in advance. 

 

Thank you!

Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Yes Anonymous 

    You can you multiple conditions in switch statements from different tables. Please use variable and switch statements.
    Like one example

    Measure = VAR _1stColumn = SELECTEDVALUE(your column)
    VAR _2ndColumn = SELECTEDVALUE(your column)
    RETURN
    SWTICH(
    TURE(),
    Condition like you shared image)

    I understand you can't share project-specific documents, it makes sense.
    Please create a sample record and share it with the expected result. So you get answers quickly
    Please ref this article
    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    If solves your requirement, please mark it as SOLUTION. Appreciate your KUDOS 

    Thanks
    Pijush




2 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Yes Anonymous 

    You can you multiple conditions in switch statements from different tables. Please use variable and switch statements.
    Like one example

    Measure = VAR _1stColumn = SELECTEDVALUE(your column)
    VAR _2ndColumn = SELECTEDVALUE(your column)
    RETURN
    SWTICH(
    TURE(),
    Condition like you shared image)

    I understand you can't share project-specific documents, it makes sense.
    Please create a sample record and share it with the expected result. So you get answers quickly
    Please ref this article
    https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    If solves your requirement, please mark it as SOLUTION. Appreciate your KUDOS 

    Thanks
    Pijush




  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    You can try this:

    Measure =
SWITCH(
    TRUE(),
    Judgment condition 1 && Judgment condition 2 && Judgment condition 3 && Judgment condition 4， “output1”
    Judgment condition 5， “output2”
)


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.