Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
irushidm
Advocate I
Advocate I

Conditional formatting in a table

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.

 

TypeSaleGross ProfitNP
Budget1000600200
Actual1100 (Green)590 (Red)190 (Red)

 

4 REPLIES 4
ishratkhan
New Member

  • =if(actual sale>=1000,green,red) than it can be put as field value (Fx)
v-viig
Community Champion
Community Champion

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

pbicvsupport@microsoft.com

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

v-viig
Community Champion
Community Champion

@irushidm

 

As far as I know it's impossible unfortunately.

Power BI table and matrix visuals aren't custom ones. Could you please create a question here?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors