Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I have a Matric report as below
I want the values to be in RED if the Period is greater than the Sell by date.
For ex. in the screenshot below. The first row has 03/31/23 as the sell by date. So all values after that date should be in RED color.
Also I want the row for the Forecast Release to be in Green Background.
Example below
Any help is appreciated
Sridhar
Solved! Go to Solution.
This worked. I added a column to my view called CELL_COLOR. Using a CASE statement, I populated the values as RED if the PERIOD > SELL_BY DATE. Then I used this column in the Conditional Formatting and set the background FONT to RED if the CELL_COLOR is RED.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
64 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
59 | |
45 | |
43 | |
38 |