Back
How can I format a conditional text column if it not meet a criteria
Eg:
I want to format the data with a,b,c which is not equal to x
ID | code | letter ------------------ 1 | 123 | a 2 | 345 | b 3 | 567 | x 4 | 789 | c -----------------
Use the following measure
Measure = If(FIRSTNONBLANK('Table'[letter]; [letter]) = "x"; BLANK(); "#AABBCC")
Want to learn more about Power Bi, Refer & learn Power bi
Also, check out our YouTube video to know the data visualization basics and best practices with Power BI
31k questions
32.8k answers
501 comments
693 users