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

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.

Reply
dmalways65
Regular Visitor

Conditional Formatting of Fields in Paginated Reports

Good Day,

 

I have created a Power BI Paginated Report using Report Builder.  One of the fields that is in my report needs to have color associated with the TEXT in the field.  So for example - if the field says "ON HOLD" the FONT Color needs to be RED.  Is this possible at all with Paginated Reports?  I've searched for videos, etc., but can't find anything specific.  Any suggestions or links to documentation that I could read?

 

Thanks

1 ACCEPTED SOLUTION
dmalways65
Regular Visitor

Thank you all - I figured it out by doing nested IF statements in the Background field. Here is what I used in case there are others out there trying to figure this out. Background Color Expression:   =IIF(Me.Value="Ongoing Company Contact", "Green",IIF(Me.Value="On-Hold", "Red",IIF(Me.Value="In-Progress", "Yellow", "Black")))

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@dmalways65 

Glad you fixed it, and Thanks for sharing, people with same question could find the solution quickly.

 

Paul Zheng _ Community Support Team

dmalways65
Regular Visitor

Thank you all - I figured it out by doing nested IF statements in the Background field. Here is what I used in case there are others out there trying to figure this out. Background Color Expression:   =IIF(Me.Value="Ongoing Company Contact", "Green",IIF(Me.Value="On-Hold", "Red",IIF(Me.Value="In-Progress", "Yellow", "Black")))

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

April Fabric Community Update

Fabric Community Update - April 2024

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

March 2024 PBI Gallery Image

Power BI Monthly Update - March 2024

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