Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Help: Conditional formatting based on a column and TC Name and a value associated with that TC name on the spreadsheet.
Example table below:
TC Name | Project # | Ave Load (CF applies here) |
TC1 | 0 | 0% |
TC2 | 25 | 218% |
TC3 | 7 | 44% |
TC4 | 16 | 114% |
So I was giving a R/Y/G fill for the percentages in the "Ave Load" column. I used conditional formatting in a regular pivot and used a formula which I based on looking up the TC name and finding the figure associated with each TC for a max/min load. I used the TC name to look up the value and if it was over the max % listed in the table it codes it Red, if it was between the max & min % it is green and anything under the min % is yellow. Worked great.
the lookup formula in the regular pivot:
=vlookup(TC Name,*ARRAY*,Max load (or min load),false)
Moving everything to Power BI I cannot figure out how to do the same and I would like the same table in my reports. You cannot enter a formula in the conditional formatting (at least not that I can figure out) I hope I am explaining this well enough so you fine folks can probably tell me I'm over complicating it and help point me in the right direction. Any help is appreciated. Thanks
Hi @Bjohnson07
It seems you may create measures with IF condition and use it for conditional formatting like this post. If you need further help, please provide more details about the max/min or share the .pbix file for us. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Cherie
Hi @Bjohnson07
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.
Regards,
Cherie
@Bjohnson07 you can surely achieve it, do you have ranges for each tc name to show case how it will work?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |