Forum Discussion
Conditional Format based on Text - NOT COUNT - How to Remove Count
Hello,
I apologize for the late feedback I was in appointments.
- You have the Power BI Desktop Client.
- Here you go on save and save it somewhere where you can find the file afterwards.
- You then open an Onedrive or Google Drive or any other fileshare and upload this file.
- Then you send me the link to this file.
Don't think about workspaces or the like - all I care about is that I get this Power BI file and since you can't upload FIles in this forum, you have to send me a link to your file
Have a nice day!
BR,
Josef
Thx for clarification JosefPrakljacic ; I've provided a link below using the Box site.
I was able to get the colorization to work using 2 diff methods but neither of which are good/or work as desired..
Method 1:
Using the TEST001 file (found at the link) I was able to use this to match a column of text against a column of text... IF match, then it colorized as desired. (I mixed hex color refs and wording to see if there were limitations but both worked great.) Problem is, this is not exactly what I need...
My Background Color = IF([Sent_Received] = [Recon_Built], "#85ff33", IF([Sent_Received] = [Recon_Built], "Yellow", "Red" ))
When you open the TEST001 file/project, you'll find no colors working because I changed the script to more what I NEED to occur.. (obviously it's not the correct syntax or something else is keeping this simplistic version from working).. If you or anyone can help correct the below -- it's what I'd prefer:
My Background Color = IF([Recon_Built] = [Complete], "#85ff33", IF([Recon_Built] = [In-Progress], "Yellow", "Red" ))
I won't talk about the other method I used in a diff file just yet because it works - but hate that option because it required many, many steps to accomplish. Thanks in advance, Chris
Link to Test001: