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.
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
Solved! Go to Solution.
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")))
Glad you fixed it, and Thanks for sharing, people with same question could find the solution quickly.
Paul Zheng _ Community Support Team
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")))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |