Back

Explore Courses Blog Tutorials Interview Questions
0 votes
3 views
in BI by (11.1k points)

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
-----------------

1 Answer

0 votes
by (22.5k points)
edited by

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

 

Related questions

0 votes
1 answer
0 votes
1 answer
asked Dec 21, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Feb 21, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Dec 13, 2020 in BI by Chris (11.1k points)

Browse Categories

...