Forum Discussion
Conditional formating on table column not working on all rows
- Anonymous2 years ago
I think it was related to having the "Show items without data" marked. When I disabled it worked.
Hi, adudani
The data comes from an API, via dataflow
Here's a a sample, extracted directly from PowerBI (Iidk how to take it except like this)
Here's also another example of how it is looking:
I is occurring on several columns, but here's one example of the DAX of one them:
_Calculated_InvestigationLevelCheck =
IF(RIGHT([CaseType L1],8) = "Incident",
IF(
OR(
OR(
AND(
[InvestigationLevel]="Level 3",
[RiskArea Int]<3
),
AND(
[InvestigationLevel]="Level 2",
[RiskArea Int]<2
)
),
AND(
[InvestigationLevel]="Level 3",
[AuthorityNotifiedName]="ANP (Brazilian Petroleum Agency)"
)
),
"Investigation Level Incorrect",
"Investigation Level correct"
),
BLANK()
)
I did try to use the SWITCH function as you suggested, but it is still behaving weird:
_Calculated_AuthorityNotifiedCheck =
SWITCH(RIGHT([CaseType L1],8),"Incident",
SWITCH(
TRUE(),
AND(
[AuthorityNotified] = "Authority not Notified",
ISTEXT([AuthorityNotifiedName])
),
"Error on Authority Notified",
"Authority Notified correct"
),
BLANK()
)
If there's any other info I can send, let me know.
Thanks.
Is this the expected output? ( the CF measure can be applied to all other column cell elements if required)
- Anonymous2 years agoNot applicable
Actually no. I need differenc CF for each column.
The problem for me is that it is only working for a few rows.
But should I try using Measures to base the CF instead of the columns itself?
- adudani2 years ago
Memorable Member
The switch logic provided in the pbix file will enable you to create different CF measures for different columns. The screenshot above is to demonstrate that the function will work for all rows in the selected column.
- Anonymous2 years agoNot applicable
Got it, but unfortunatelly it is still only working for a few rows.
- Anonymous2 years agoNot applicable
I think it was related to having the "Show items without data" marked. When I disabled it worked.