Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi how can you use conditional formatting to colour the cell where actual positive performance in green and negative performance in red for each indicator against the budget.
Type | Sale | Gross Profit | NP |
Budget | 1000 | 600 | 200 |
Actual | 1100 (Green) | 590 (Red) | 190 (Red) |
Hello @irushidm,
Could you please clarify you used Power BI Table visual or developed your own table custom visual?
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi what i have shown above is something i did on MS word. With the power BI table/matrix visual i am unable to colour status of the actual performance which is depicted in the second row. If its lower than budget the background colour of the cell/font colour should be red and if its above budget background colour of the cell/font colour should be green. I want to be able present data in that format. Is this possible with Power BI? This is similar to the conditional formatting availble in Excel.
Thanks
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.