Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a table called 'Legal Files' column name is Description_1 (Visual shows Description).
I was able to color code when "Letter Waived" is in the column to show the font as BLUE. But now it's been asked to keep that AND anytime the word "person" or "WebEx" is used for the font to be RED and "Dispo" to be BLUE.
When I do Status Color = SWITCH('Legal Files'[Description_1], "Dispo",1, "Letter Waived",2, "Person",3, "WebEx",4)
This doesn't work because there is other text in the column so it's not exactly just the words being used.
How else can I get the text to change color when the column contains those words?
Solved! Go to Solution.
We have a winner! Thank you.
In power query, select the description column, create a new column by example, type out the required word in two or three rows, the required words automatically get filled in. You can use the new column in the SWITCH() condition
I'm thinking this isn't going to work.
Error even when I tried Letter Waived instead of LW. (in the raw data it comes over as LW.
I'll have to try something different.
Please check my latest reply.
@Padycosmos this does not help. Watching the video it has to do with numbers and doesn't translate to text. Also in the video the numbes are not in the same Column they are in differnt rows.
I need color coding for TEXT in the same Column.
I understand. Please try changing the format style to Field Value as shown below
That's not working either.
In the conditions, you can use the conditions "Person" || "Webex", 3, "Letter Waived" || "Dispo",1
@Padycosmos in the youtube video you sent it's using
How do I convert this when I'm not using numbers? What formula should I be using in order to get the conditional formating to work?
I have never tried this with a text column and I do not have sample data at the moment. So you may try changing the conditions as shown below: and use numbers as you have used hitherto.
In the conditions, you can use the conditions
SWITCH(TRUE(),'Legal Files'[Description_1], "Letter Waived" || "Dispo",1,"Person" || "Webex", 2)
The '||' symbol is in this key Press Shift+this key twice
Sorry about that. Please try this.
SWITCH(TRUE(),'Legal Files'[Description_1]= "Letter Waived" || "Dispo",1,'Legal Files'[Description_1]="Person" || "Webex", 2)
@Padycosmos I tired as a new Measure and as a new Column, both are not working.
As a Column:
As a Measure:
A solution at last. It is a measure
@Padycosmos The data has PPI so I can not share.
What am I doing wrong?
But also notice there is other text in the Column not just the words I'm calling out, so that's part of the problem I'm having. I was able to create a measure to make when "Letter Waived" is in the text to make it all blue. But I'm not able to add if "person" or "webex" is there make it red.
@Padycosmos I tried both of these
This works even if the text contains other values.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
145 | |
79 | |
64 | |
52 | |
47 |
User | Count |
---|---|
216 | |
89 | |
76 | |
67 | |
60 |