--- title: "POWER BI: New Release - String Conditional Formatting" description: String conditional formatting is a technique used to apply formatting rules to cells in a spreadsheet based on the contents of the cell's text. This new release; conditional formatting for string fiel image: https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/Untitled-design-2.jpg --- [Skip to content](https://resources.sempreanalytics.com/blogs/power-bi-new-release-string-conditional-formatting#main-content) - What We Do Design & Deliver [Enterprise Performance Management Accurately plan, forecast & budget to improve performance](https://www.sempreanalytics.com/enterprise-performance-management/) [Business Intelligence Answer key business questions using data](https://www.sempreanalytics.com/business-intelligence/) [Data Management Integrate, organise, secure and govern your data](https://www.sempreanalytics.com/data-management/) [Intelligent Automation Automate routine and repetitive tasks](https://www.sempreanalytics.com/intelligent-automation/) Optimise & Support [Managed Services The support you need, when you need it](https://www.sempreanalytics.com/managed-service/) [Training Services Increase the power of your data for decision making](https://www.sempreanalytics.com/sempre-analytics-training-courses/) Technologies [Anaplan](https://www.sempreanalytics.com/anaplan/) [Automation Anywhere](https://www.sempreanalytics.com/automation-anywhere/) [IBM](https://www.sempreanalytics.com/ibm-technologies/) [Informatica](https://www.sempreanalytics.com/informatica/) [Microsoft](https://www.sempreanalytics.com/microsoft/) - Who We Help Who We Help [Housebuilding & Construction Building scalable financial and operational planning solutions](https://www.sempreanalytics.com/housebuilding-construction/) [Retail Using data to improve customer experience and drive operational efficiency.](https://www.sempreanalytics.com/retail/) [Higher Education Enabling data driven decision making in Higher Education.](https://www.sempreanalytics.com/higher-education/) [Financial Services Enabling data driven decision making in Financial Services.](https://www.sempreanalytics.com/financial-services/) [Manufacturing Making effective and sustainable data driven decisions that improve business outcomes.](https://www.sempreanalytics.com/manufacturing-distribution/) Sector Insights [![claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1-200x200](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/menu/claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1-200x200.jpg?width=200&height=200&name=claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1-200x200.jpg)](https://www.sempreanalytics.com/clothing-retail-without-the-data-wheres-the-brand-resilience/) [Retail and Consumer Goods](https://www.sempreanalytics.com/category/industry-solutions/retail) [Clothing Retail: Without the Data, Where’s the Brand Resilience?](https://www.sempreanalytics.com/clothing-retail-without-the-data-wheres-the-brand-resilience/) [![iStock-1297914649-200x200](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/menu/iStock-1297914649-200x200.jpg?width=200&height=200&name=iStock-1297914649-200x200.jpg)](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) [Planning and Analytics](https://www.sempreanalytics.com/category/financial-planning) [Beyond IFRS 17: Data integration is a huge opportunity for insurance finance, not a compliance-related chore](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) [![jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1-200x200](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/menu/jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1-200x200.jpg?width=200&height=200&name=jeriden-villegas-niSnhfMjiMI-unsplash-scaled-1-200x200.jpg)](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) [Planning and Analytics](https://www.sempreanalytics.com/fixing-remedial-costs-for-uk-housebuilders-data-integration-means-greater-business-resilience/) [Fixing remedial costs: for UK housebuilders, data integration means greater business resilience](https://www.sempreanalytics.com/beyond-ifrs-17-data-integration-is-a-huge-opportunity-for-insurance-finance-not-a-compliance-related-chore/) - What We Are Resources & Support [Help Desk Accurately plan, forecast & budget to improve performance](https://www.sempreanalytics.com/help-desk/) [Our Blogs The latest Sempre expert insights and industry blogs](https://www.sempreanalytics.com/blogs/) [Our Events The latest Sempre events](https://www.sempreanalytics.com/events/) [Our Resources Dive into our latest content](https://www.sempreanalytics.com/resources/) Learn & Connect [Company Motivated by mission and purpose](https://www.sempreanalytics.com/company/) [Customer Stories Success stories from our clients](https://www.sempreanalytics.com/customer-stories/) [Our Approach Understand the things that make us different.](https://www.sempreanalytics.com/company/our-approach/) [Careers Latest career opportunities at Sempre Analytics](https://www.sempreanalytics.com/careers/) [Talk To Us Whatever challenge you face we’re here to help](https://www.sempreanalytics.com/contact/) Featured Insights [![Building Sales, Partnerships and People at Sempre](https://resources.sempreanalytics.com/hubfs/MicrosoftTeams-image%20(3).png)](https://resources.sempreanalytics.com/blogs/building-partnerships) [General](https://resources.sempreanalytics.com/blogs/tag/general) [Building Sales, Partnerships and People at Sempre](https://resources.sempreanalytics.com/blogs/building-partnerships) [![Funding Changes: What does it mean for Housing Associations and their Finance Teams](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/claudio-hirschberger-VI1UCQe4U4A-unsplash-1800x1125-1.jpg)](https://resources.sempreanalytics.com/blogs/housing-associations-rent-convergence) [Anaplan](https://resources.sempreanalytics.com/blogs/tag/anaplan) [Funding Changes: What does it mean for Housing Associations and their Finance Teams](https://resources.sempreanalytics.com/blogs/housing-associations-rent-convergence) [![What’s New in Cognos 12.1.0 - The Story So Far…](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/AdobeStock_889788354-scaled-1.jpg)](https://resources.sempreanalytics.com/blogs/cognos-12-1-0) [IBM Cognos Analytics](https://resources.sempreanalytics.com/blogs/tag/cognos-analytics) [What’s New in Cognos 12.1.0 - The Story So Far…](https://resources.sempreanalytics.com/blogs/cognos-12-1-0) - [Talk to us](https://www.sempreanalytics.com/contact/) [Talk to us](https://www.sempreanalytics.com/contact/) ![POWER BI: New Release - String Conditional Formatting](https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/Untitled-design-2.jpg) by [Andy Copeland](https://resources.sempreanalytics.com/blogs/author/andy-copeland) ![Andy Copeland](https://resources.sempreanalytics.com/hubfs/Blog_authors/Andy%20Copeland.jpg) [mailto:andy.copeland@sempreanalytics.com](mailto:andy.copeland@sempreanalytics.com) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) # POWER BI: New Release - String Conditional Formatting The new release of **conditional formatting for string fields in Power BI** had a positive impact on the user experience. Prior to this update, users were limited in their ability to format string fields in their reports, especially when using column charts and bar charts. With the new release, users now have more flexibility and control over how string fields are formatted. This makes it easier to highlight important information and improves the overall readability of their reports.  In addition to conditional formatting, the new release also allows users to apply formatting based on data bars, color scales, and icons. This provides users with additional visual cues to help them quickly understand and interpret their data. Overall, the new release of **conditional formatting for string fields in Power BI** has made it easier for users to create visually appealing and informative reports. It has given users more control over how their data is presented, making it easier to spot patterns and trends, and ultimately helping users make better-informed decisions. **How to apply conditional formatting to string fields in Power BI!** **POST NEW RELEASE** In the past, applying a conditional format to a string field in Power BI was not straightforward - especially when dealing with table visuals. However, DAX was used to provide a workaround (Using IF statement or SWITCH function) and format style >> ‘Field value’ >> then select the measure you created >> click ‘ok’. This automatically applies the colours stated to the fields. An Example as shown below: **The Measure:** ![The Measure image](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/The%20Measure%20image.png?width=836&height=627&name=The%20Measure%20image.png) **The Result:** ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/result-2.png?width=210&height=160&name=result-2.png) **NEW RELEASE** Now in the new feature released last month (Feb.2023), string conditional formatting in Power BI is a lot easier and straightforward without the use of DAX. *“We know that* [*many users have been asking for this feature*](https://ideas.powerbi.com/ideas/idea/?ideaid=8f71768f-9894-4e5c-a16f-9b0765383eab)*, so Microsoft are excited to be bringing you this feature and hope you find it a powerful new conditional formatting capability.”* Conditional formatting in Power BI allows users to apply formatting rules to visual elements based on specific conditions. This can be very useful when trying to highlight important data or when trying to draw attention to specific trends or patterns. In order to apply conditional formatting to string fields in Power BI, we need to follow a few simple steps. **Step 1: Create a visual element** The first step in applying conditional formatting to string fields in Power BI is to create a visual element that we want to format. This could be a table, a chart, or any other visual element that displays data. **Step 2**: **Add the string field to the visual element** Next, we need to add the string field that we want to format to the visual element. This can be done by selecting the field in the Fields pane and dragging it onto the visual element. **Step 3: Click on the visual element** Once the string field has been added to the visual element, we need to click on the visual element to select it. **Step 4**: **Open the Formatting pane** With the visual element selected, we need to open the Formatting pane by clicking on the paint roller icon in the Visualizations pane. **Step 5:** **Select the conditional formatting option** In the formatting pane, we need to select the conditional formatting option by clicking on the data bars icon. **Step 6:** **Choose the string field** With the conditional formatting option selected, we need to choose the string field that we want to format from the dropdown menu. **Step 7:** **Choose the formatting rule** Once we have selected the string field, we can choose the formatting rule that we want to apply. This could be a color scale, a data bar, or any other formatting option that is available. **Step 8**: **Choose the formatting options** Finally, we need to choose the formatting options for the formatting rule that we have selected. This could include choosing the color scheme, the minimum and maximum values, and any other options that are available. *Now select the visual >> Format your visual >> Cell elements >> Series >> Background color >> Format style ‘Rules’ >> search the field name >> fill in the ‘IF statement rule’.*  ![After Step 8](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/After%20Step%208.png?width=460&height=272&name=After%20Step%208.png) **The Result:** ![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/The-Result.png?width=191&height=154&name=The-Result.png) By following these simple steps, we can apply conditional formatting to string fields in Power BI. This can be very useful when trying to highlight important data or when trying to draw attention to specific trends or patterns. With Power BI's powerful conditional formatting options, we can create visually stunning reports and dashboards that make it easy to understand complex data. Also, When it comes to applying conditional formatting to string fields in Power BI, there are both pros and cons to consider. **PROS:** 1. Highlight important information: Conditional formatting can help you to highlight specific data values that are important or require attention, making it easier to focus on key information and take action accordingly. 2. Improved readability: By using conditional formatting to visually differentiate between different values in a string field, you can improve the readability of the data, making it easier to understand and analyze. 3. Quick identification of trends: Using conditional formatting, you can easily identify trends in your data, such as which products are selling the most or which regions are experiencing the highest sales growth. **CONS:** 1. Overuse can be distracting: If you apply conditional formatting to too many values or fields, it can become visually overwhelming and distracting, making it difficult to focus on the most important information. 2. Potential for bias: The use of conditional formatting can potentially introduce bias into your analysis, particularly if the formatting choices are subjective and influenced by personal preferences or assumptions. 3. Complexity and maintenance: Conditional formatting can be complex to set up and maintain, particularly when dealing with large amounts of data or complex rules. It can also slow down the performance of your report or dashboard if applied too extensively. Overall, conditional formatting can be a useful tool when applied thoughtfully and in moderation, helping to enhance the visual presentation of your data and highlight key insights. However, it is important to consider the potential drawbacks and weigh them against the benefits before applying them to string fields in Power BI. --- ##### **Ayo Oludare** is a highly skilled data analyst and data visualization expert with extensive experience in M code, Cognos ReportNet, SQL Server Reporting Services (SSRS), Microsoft Excel, Microsoft Power BI, and DAX. Ayo's strong background in data analysis and problem-solving makes him a valuable asset in any data-related project. ##### Ayo has a proven track record of using M code to transform and manipulate data effectively. He is skilled in using Cognos ReportNet and SSRS to create complex and dynamic reports. Ayo is also highly proficient in using Microsoft Excel and Power BI for data analysis and visualization. ##### Ayo's expertise in DAX enables him to create custom calculations and aggregations in Power BI and other Microsoft products. He has a keen eye for detail and is highly analytical, which allows him to identify and resolve issues that arise during the data analysis process. ##### With his diverse skill set and extensive experience, Ayo Oludare is well-equipped to handle a wide range of data-related tasks and projects. He is a dedicated and highly motivated individual who is passionate about using data to drive business insights and decision-making.   ## About the author **Andy Copeland** Experienced solutions architect who has many years experience in IBM Cognos Business Intelligence. In that time I have built up an excellent understanding of client requirements and a proven track record of delivering excellent Business Analytics and FPM Solutions that are reliable, scalable and deliver results. I also have a great deal of experience providing and managing an excellent customer service function in the Cognos arena. I also specialise in the system specification and design of integrated BI, Planning, Controller and TM1 environments and offer advice to other IBM Partners on the best practice approach to implementation. I am also a regular contributor to various IBM Cognos related forums and posting information on my blog to assist others who might be facing the same challenges. ## Related posts [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/thisisengineering-raeng-yhCHx8Mc-Kc-unsplash-scaled-1.jpg?width=352&name=thisisengineering-raeng-yhCHx8Mc-Kc-unsplash-scaled-1.jpg) 8 June 2021](https://resources.sempreanalytics.com/blogs/cognos-analytics-11-2) [Planning and Analytics](https://resources.sempreanalytics.com/blogs/tag/financial-planning) ### [Cognos Analytics 11.2 – A true discovery my dear Watson](https://resources.sempreanalytics.com/blogs/cognos-analytics-11-2) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Blog/Website-logo.jpg?width=352&name=Website-logo.jpg) 21 June 2021](https://resources.sempreanalytics.com/blogs/increasing-reporting-capabilities-from-planning-analytics-using-cognos-analytics) [Planning and Analytics](https://resources.sempreanalytics.com/blogs/tag/financial-planning) ### [Increasing reporting capabilities from Planning Analytics using Cognos Analytics](https://resources.sempreanalytics.com/blogs/increasing-reporting-capabilities-from-planning-analytics-using-cognos-analytics) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/lukas-blazek-mcSDtbWXUZU-unsplash-scaled-1.jpg?width=352&name=lukas-blazek-mcSDtbWXUZU-unsplash-scaled-1.jpg) 10 September 2020](https://resources.sempreanalytics.com/blogs/expand-the-reach-of-your-analytics-with-cognos-analytics-release-11-1-7-2) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) ### [Expand the reach of your analytics with Cognos Analytics release 11.1.7](https://resources.sempreanalytics.com/blogs/expand-the-reach-of-your-analytics-with-cognos-analytics-release-11-1-7-2) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/pexels-tirachard-kumtanom-733854.jpg?width=352&name=pexels-tirachard-kumtanom-733854.jpg) 13 May 2020](https://resources.sempreanalytics.com/blogs/whats-new-in-cognos-analytics-11-1-6) [Data Management](https://resources.sempreanalytics.com/blogs/tag/data-management) ### [What's new in Cognos Analytics 11.1.6](https://resources.sempreanalytics.com/blogs/whats-new-in-cognos-analytics-11-1-6) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/linkedin-sales-solutions-46bom4lObsA-unsplash.jpg?width=352&name=linkedin-sales-solutions-46bom4lObsA-unsplash.jpg) 31 October 2018](https://resources.sempreanalytics.com/blogs/motio-is-now-in-the-cognos-box) [IBM Cognos Analytics](https://resources.sempreanalytics.com/blogs/tag/cognos-analytics) ### [Motio is now in the Cognos Box!](https://resources.sempreanalytics.com/blogs/motio-is-now-in-the-cognos-box) [![](https://resources.sempreanalytics.com/hs-fs/hubfs/Imported_Blog_Media/Informatica-1.jpg?width=352&name=Informatica-1.jpg) 21 September 2021](https://resources.sempreanalytics.com/blogs/sempre-analytics-awarded-informatica-platinum-reseller-status) [Latest News](https://resources.sempreanalytics.com/blogs/tag/latest-news) ### [Sempre Analytics Awarded Informatica Platinum Reseller Status](https://resources.sempreanalytics.com/blogs/sempre-analytics-awarded-informatica-platinum-reseller-status) ![anaplan-logo](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/anaplan-logo.svg) ![automation-anywhere-logo](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/automation-anywhere-logo.svg) ![ibm-logo-346x170](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/ibm-logo-346x170.png?width=346&height=170&name=ibm-logo-346x170.png) ![informatica-logo](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/informatica-logo.svg) ![microsoft-logo-346x170](https://resources.sempreanalytics.com/hs-fs/hubfs/Sempre%20Analytics%20-%202025/Images/Global/microsoft-logo-346x170.jpg?width=346&height=170&name=microsoft-logo-346x170.jpg) Industry Solutions - [Finance, Insurance & Services](https://www.sempreanalytics.com/financial-services/) - [Housebuilding & Construction](https://www.sempreanalytics.com/housebuilding-construction/) - [Manufacturing & Distribution](https://www.sempreanalytics.com/manufacturing-distribution/) - [Retail & Consumer Goods](https://www.sempreanalytics.com/retail/) - [Higher Education](https://www.sempreanalytics.com/higher-education/) Technologies - [Anaplan](https://www.sempreanalytics.com/anaplan/) - [Automation Anywhere](https://www.sempreanalytics.com/automation-anywhere/) - [IBM Cognos Analytics](https://www.sempreanalytics.com/ibm-cognos-analytics/) - [IBM Controller](https://www.sempreanalytics.com/ibm-controller/) - [IBM Planning Analytics](https://www.sempreanalytics.com/ibm-planning-analytics/) - [Informatica](https://www.sempreanalytics.com/informatica/) - [Microsoft Data Platform](https://www.sempreanalytics.com/microsoft/) Learn & Connect - [Company](https://www.sempreanalytics.com/company/) - [Customer Stories](https://www.sempreanalytics.com/customer-stories/) - [Our Approach](https://www.sempreanalytics.com/company/our-approach/) - [Careers](https://www.sempreanalytics.com/careers/) - [Resources](https://www.sempreanalytics.com/resources) - [Talk To Us](https://www.sempreanalytics.com/contact/) - [Helpdesk ![extension](https://resources.sempreanalytics.com/hubfs/Sempre%20Analytics%20-%202025/Images/Global/external.svg)](https://www.sempreanalytics.com/help-desk/) [Talk to us](https://www.sempreanalytics.com/contact/) - - - [Privacy Policy](https://www.sempreanalytics.com/privacy/) - [Cookie Policy](https://www.sempreanalytics.com/cookie-policy/) - [Web Design by Fhoke](https://www.fhoke.com/) © 2026 Sempre Analytics ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Andy Copeland", "url" : "https://resources.sempreanalytics.com/blogs/author/andy-copeland" }, "dateModified" : "2025-07-11T07:55:22.011Z", "datePublished" : "2023-03-27T13:06:44.000Z", "headline" : "POWER BI: New Release - String Conditional Formatting", "image" : [ "https://resources.sempreanalytics.com/hubfs/Imported_Blog_Media/Untitled-design-2.jpg" ], "mainEntityOfPage" : { "@id" : "https://resources.sempreanalytics.com/blogs/power-bi-new-release-string-conditional-formatting", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://resources.sempreanalytics.com/hubfs/Sempre%20-%20logo%20-%20smaller.jpg" }, "name" : "sempre analytics" } } ```