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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Ciuciek
New Member

Conditional formatting matrix columns

Hi,

I've created P&L matrix (random data) showing in columns Actuals, Forecasts and Actuals vs Forecasts. I would like to apply conditional formating only to columns Actuals vs Forecasts and still have possibility to change versions by slicer as it is on the screenshot. Is there any solution for that? I've tried to create a measure but then the measure column is showing after ACT column and after RF3 column. I've also tried to change database layout but couldn't find any solution.

Thanks a lot!

Ciuciek_0-1645010163046.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Ciuciek , In matrix conditional formatting, can only happen for Values. Not for Row or column (pivot) 

 

 

For value formatting you can create a measure if needed and use that in conditional formatting using field value option

example

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

 

Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Ciuciek , In matrix conditional formatting, can only happen for Values. Not for Row or column (pivot) 

 

 

For value formatting you can create a measure if needed and use that in conditional formatting using field value option

example

Color = if(FIRSTNONBLANK('Table'[Year],2014) <=2016 && AVERAGE(Sales[Sales Amount])<170
,"lightgreen",if(FIRSTNONBLANK('Table'[Year],2014)>2018,"red","yellow"))

 

Color sales = if([Sales Today] -[sales yesterday]>0,"green","red")

 

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks, it is working. I recommend everybody watch @amitchandak youtube video: https://youtu.be/RqBb5eBf_I4

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.