Forum Discussion
Conditional Formatting - more than one condition from a different table
- 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
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