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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors