Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Format based on Text - NOT COUNT - How to Remove Count

I'm trying to utilize the following method to colorize background of cells based upon the status TEXT that's in them. I found a video that demonstrated this method, but in the video the person was ab...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

1st wk newbie here, had to go figure out how to create a new workspace to add a test file to it that did not hold private data. (check/done) -- now that I've done that I'm not seeing how to generate/get a link to be able to share that file OR that new test workspace with you... Assume that when a link is generated that it is only to that one file and the other party has no other access to other files correct? Can you tell me how to collect a link to that one file within that new "TEST" workspace to share w/ you? JosefPrakljacic 

 

Alternatively, would it be easier to adjust the "Measure" method with whatever functions you mentioned? Thx

JosefPrakljacic's avatar
JosefPrakljacic
Solution Sage
6 years ago

Hello,

I apologize for the late feedback I was in appointments.

 

  1. You have the Power BI Desktop Client.
  2. Here you go on save and save it somewhere where you can find the file afterwards.
  3. You then open an Onedrive or Google Drive or any other fileshare and upload this file.
  4. Then you send me the link to this file.
  5.  

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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:

    https://app.box.com/s/4dq49w6fznash4gqfk11oa6sx72kj4y6