{"id":43376,"date":"2025-10-07T21:28:12","date_gmt":"2025-10-07T16:28:12","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=43376"},"modified":"2026-04-17T22:57:45","modified_gmt":"2026-04-17T17:57:45","slug":"conditional-formatting-in-power-bi","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi","title":{"rendered":"Conditional Formatting in Power BI for Advanced Analytics"},"content":{"rendered":"<p>Conditional formatting in Power BI is a feature that allows users to highlight and draw attention to important data trends in their visualizations. By applying color-coded formatting to specific criteria, users (and other stakeholders) can quickly and easily identify patterns and outliers in their data sets.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/conditional-formatting-in-power-bi.jpg\" alt=\"Conditional Formatting in Power BI\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2NjkrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTY2OSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTY2OSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>In this guide, you&#8217;ll discover the benefits of the Power BI conditional formatting function and how to apply a conditional format in a Power BI matrix\/table.<\/p>\n<h3>Table of Content:<\/h3>\n<ol>\n<li><a href=\"#what-is-conditional-formatting-in-power-bi\">What is Conditional Formatting in Power BI?<\/a><\/li>\n<li><a href=\"#why-use-power-bi-conditional-formatting\">Why Use Power BI Conditional Formatting?<\/a><\/li>\n<li><a href=\"#conditional-formatting-power-bi-common-types\">Conditional Formatting Power BI: Common Types<\/a><\/li>\n<li><a href=\"#how-to-apply-conditional-formatting-in-power-bi-matrix-table\">How to Apply Conditional Formatting in Power BI Matrix\/Table?<\/a>\n<ul>\n<li><a href=\"#power-bi-conditional-formatting-based-on-field-value\">Power BI Conditional Formatting Based on Field Value<\/a><\/li>\n<li><a href=\"#power-bi-conditional-formatting-based-on-measure\">Power BI Conditional Formatting Based on Measure<\/a><\/li>\n<li><a href=\"#conditional-formatting-in-power-bi-using-dax\">Conditional Formatting in Power BI Using DAX<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-use-conditional-formatting-in-power-bi\">How to Use Conditional Formatting in Power BI?<\/a><\/li>\n<li><a href=\"#how-to-interpret-conditional-formatting-in-power-bi\">How to Interpret Conditional Formatting in Power BI?<\/a><\/li>\n<li><a href=\"#how-to-remove-power-bi-conditional-formatting\">How to Remove Power BI Conditional Formatting?<\/a><\/li>\n<li><a href=\"#benefits-of-using-power-bi-conditional-formatting-function\">Benefits of Using Power BI Conditional Formatting Function<\/a><\/li>\n<li><a href=\"#top-5-conditional-formatting-mistakes-in-power-bi\">Top 5 Conditional Formatting Mistakes in Power BI<\/a><\/li>\n<li><a href=\"#tips-for-advanced-conditional-formatting-in-power-bi\">Tips for Advanced Conditional Formatting in Power BI<\/a><\/li>\n<li><a href=\"#conditional-formatting-in-power-bi-faqs\">Conditional Formatting in Power BI &#8211; FAQs<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<p>First&#8230;<\/p>\n<h2 id=\"what-is-conditional-formatting-in-power-bi\">What is Conditional Formatting in Power BI?<\/h2>\n<p><strong>Definition: <\/strong>Conditional formatting in Power BI is a feature that automatically changes the appearance of data\u2014such as background color, font color, icons, or data bars\u2014based on specific rules or conditions. It helps users highlight important values, identify trends, and make reports easier to read and interpret by visually emphasizing key insights.<\/p>\n<h2 id=\"why-use-power-bi-conditional-formatting\">Why Use Power BI Conditional Formatting?<\/h2>\n<p data-start=\"236\" data-end=\"360\">Power BI conditional formatting makes your reports clearer and more insightful by highlighting key data automatically.<\/p>\n<p data-start=\"362\" data-end=\"377\">It helps you:<\/p>\n<ul>\n<li data-start=\"380\" data-end=\"453\"><strong data-start=\"380\" data-end=\"416\">Spot trends and outliers quickly<\/strong> using colors, icons, or data bars.<\/li>\n<li data-start=\"456\" data-end=\"535\"><strong data-start=\"456\" data-end=\"487\">Make reports easier to read<\/strong> so users can understand insights at a glance.<\/li>\n<li data-start=\"538\" data-end=\"610\"><strong data-start=\"538\" data-end=\"566\">Support better decisions<\/strong> by drawing attention to important values.<\/li>\n<li data-start=\"613\" data-end=\"674\"><strong data-start=\"613\" data-end=\"638\">Enhance visual appeal<\/strong> and engagement across dashboards.<\/li>\n<\/ul>\n<h2 id=\"conditional-formatting-power-bi-common-types\">Conditional Formatting Power BI: Common Types<\/h2>\n<p data-start=\"206\" data-end=\"427\">Power BI provides several types of conditional formatting top 5 are as follows:<\/p>\n<ul>\n<li data-start=\"434\" data-end=\"461\">\n<h3>Background Color<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"462\" data-end=\"654\">This option changes the background color of cells based on specific values or ranges. It\u2019s useful for showing intensity, such as higher values in darker shades and lower ones in lighter tones.<\/p>\n<ul>\n<li data-start=\"661\" data-end=\"682\">\n<h3>Font Color<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"683\" data-end=\"859\">Font color formatting changes the text color according to data values. It\u2019s a simple way to emphasize differences without altering the background\u2014perfect for quick comparisons.<\/p>\n<ul>\n<li data-start=\"866\" data-end=\"886\">\n<h3>Data Bars<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"887\" data-end=\"1054\">Data bars display horizontal bars within cells to visually compare numbers. Longer bars represent higher values, making it easy to spot performance levels at a glance.<\/p>\n<ul>\n<li data-start=\"1061\" data-end=\"1077\">\n<h3>Icons<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"1078\" data-end=\"1248\">Icon sets use symbols like arrows, check marks, or warning signs to represent performance or status trends. They help users quickly identify positive or negative results.<\/p>\n<ul>\n<li data-start=\"1255\" data-end=\"1284\">\n<h3>Web URL Formatting<\/h3>\n<\/li>\n<\/ul>\n<p data-start=\"1285\" data-end=\"1447\">This feature turns cell values into clickable links that direct users to external reports, dashboards, or related resources, adding interactivity to your visuals.<\/p>\n<h2 id=\"how-to-apply-conditional-formatting-in-power-bi-matrix-table\">How to Apply Conditional Formatting in Power BI Matrix\/Table?<\/h2>\n<p>Here are easy steps to help you apply conditional formatting in Power BI for a matrix (or table):<\/p>\n<ul>\n<li>Open the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-report-examples\" target=\"_blank\" rel=\"noopener\">report in Power BI Desktop<\/a><\/li>\n<li>Create a Table (or Matrix)<\/li>\n<li>Select the Column or Data Cell<\/li>\n<li>Access the <a href=\"https:\/\/chartexpo.com\/blog\/format-dax\" target=\"_blank\" rel=\"noopener\">Formatting options<\/a><\/li>\n<li>Apply Conditional Formatting<\/li>\n<li>Choose a Formatting Rule<\/li>\n<li>Configure the Rule<\/li>\n<li>Define Rules<\/li>\n<li>Preview and Apply<\/li>\n<li>Repeat for Additional Formatting<\/li>\n<li>Save and Publish.<\/li>\n<\/ul>\n<h3>Example<\/h3>\n<p>Step-by-Step Guide to adding conditional formatting in Power BI to evaluate data, a Color by Rules:<\/p>\n<p>Select \u201cRules\u201d in the Format by field of the Background color (or Font color dialogue box to format the cell background (or font color) according to the rules. In the &#8220;Based on field&#8221; section, select the field on which the formatting is based. The &#8220;Summarization&#8221; displays the field&#8217;s aggregate type.<\/p>\n<p>Enter one or more value ranges and colors for each under Rules. There\u2019s the \u201cIf\u201d value condition, a value condition, and a color for each value range. Each value range\u2019s cell backgrounds or fonts are colored with the specified color. Look out for the three rules in the example below:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/percent-column-in-affordability-column-for-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/percent-column-in-affordability-column-for-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Percent Column in Affordability Column for Doing Conditional Formatting in Power BI\" width=\"564\" \/><\/a><\/div>\n<p>If you choose Percent from the options, the rule boundaries will be specified as a percentage of the whole range of values from lowest to maximum. If the lowest data point was 100 and the highest was 400, the preceding rules would color anything under 200 green, anything between 200 and 300 yellow, and anything over 300 red.<\/p>\n<p>The illustration table below has rules-based background color formatting dependent on the Percent column in the Affordability column:<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/look-out-for-three-rules-in-example-below-for-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/look-out-for-three-rules-in-example-below-for-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Look Out for Three Rules in Example Below for Doing Conditional Formatting in Power BI\" width=\"558\" \/><\/a><\/div>\n<h3 id=\"power-bi-conditional-formatting-based-on-field-value\">Power BI Conditional Formatting Based on Field Value<\/h3>\n<ol>\n<li data-start=\"547\" data-end=\"600\">Select your table or matrix visual in Power BI.<\/li>\n<li data-start=\"604\" data-end=\"695\">In the Values section, click the down arrow next to the field you want to format.<\/li>\n<li data-start=\"699\" data-end=\"804\">Choose Conditional formatting, then pick a format type (e.g., Background color, Font color, Icons).<\/li>\n<li data-start=\"808\" data-end=\"857\">Under Format style, select Field value.<\/li>\n<li data-start=\"861\" data-end=\"933\">Pick the field or measure that contains your color or icon values.<\/li>\n<li data-start=\"937\" data-end=\"974\">Click OK or Apply to confirm.<\/li>\n<\/ol>\n<h3 id=\"power-bi-conditional-formatting-based-on-measure\">Power BI Conditional Formatting Based on Measure<\/h3>\n<ol>\n<li data-start=\"605\" data-end=\"658\">Select your table or matrix visual in Power BI.<\/li>\n<li data-start=\"662\" data-end=\"753\">In the Values section, click the down arrow next to the field you want to format.<\/li>\n<li data-start=\"757\" data-end=\"878\">Choose Conditional formatting, then select a format type (like Background color, Font color, or Icons).<\/li>\n<li data-start=\"882\" data-end=\"929\">Under Format style, pick Field value.<\/li>\n<li data-start=\"933\" data-end=\"1015\">From the dropdown, select the measure that returns a numeric or color value.<\/li>\n<li data-start=\"1019\" data-end=\"1070\">Click OK or Apply to see your table update.<\/li>\n<\/ol>\n<h3 id=\"conditional-formatting-in-power-bi-using-dax\">Conditional Formatting in Power BI Using DAX<\/h3>\n<p>Steps for DAX conditional formatting in Power BI:<\/p>\n<ul>\n<li data-start=\"544\" data-end=\"607\">Create a new <a href=\"https:\/\/chartexpo.com\/blog\/create-a-measure-in-power-bi\" target=\"_blank\" rel=\"noopener\">measure in Power BI<\/a> using DAX.<br data-start=\"591\" data-end=\"594\" \/><strong>Example:<\/strong> SalesColor = IF(SUM(Sales[Revenue]) &gt; 50000, &#8220;#00FF00&#8221;, &#8220;#FF0000&#8221;)<\/li>\n<\/ul>\n<p data-start=\"702\" data-end=\"778\">This formula returns green for values above 50,000 and red for lower ones.<\/p>\n<ul>\n<li data-start=\"783\" data-end=\"899\">Add the measure to your model: It should output a color code or numeric result you\u2019ll use for formatting.<\/li>\n<li data-start=\"904\" data-end=\"1001\">Open your table or matrix visual: Click the down arrow beside the field to format.<\/li>\n<li data-start=\"1006\" data-end=\"1076\">Go to Conditional formatting \u2192 Background color (or Font color).<\/li>\n<li data-start=\"1081\" data-end=\"1169\">Under Format style, choose Field value and select the DAX measure you created.<\/li>\n<li data-start=\"1174\" data-end=\"1205\">Click OK to apply the rule.<\/li>\n<\/ul>\n<h2 id=\"how-to-use-conditional-formatting-in-power-bi\">How to Use Conditional Formatting in Power BI?<\/h2>\n<ol>\n<li data-start=\"601\" data-end=\"715\"><strong data-start=\"601\" data-end=\"627\">Select your visual:<\/strong> Choose the table or matrix visual where you want to apply conditional formatting.<\/li>\n<li data-start=\"717\" data-end=\"843\"><strong data-start=\"717\" data-end=\"739\">Choose a field:<\/strong> In the Visualizations pane, go to the Values section and locate the field you want to format.<\/li>\n<li data-start=\"845\" data-end=\"979\"><strong data-start=\"845\" data-end=\"876\">Open formatting options:<\/strong> Click the down arrow next to the field name and select Conditional formatting from the menu.<\/li>\n<li data-start=\"981\" data-end=\"1123\"><strong data-start=\"981\" data-end=\"1007\">Pick a format type:<\/strong> Choose a formatting style such as Background color, Font color, Data bars, Icons, or Web URL.<\/li>\n<li data-start=\"1125\" data-end=\"1279\"><strong data-start=\"1125\" data-end=\"1158\">Set your formatting logic:<\/strong> Decide whether to format by Color scale, Rules, or Field value, and define your color or value conditions.<\/li>\n<li data-start=\"1281\" data-end=\"1380\"><strong data-start=\"1281\" data-end=\"1302\">Apply changes:<\/strong> Click OK or Apply to confirm and review the results in your visual.<\/li>\n<\/ol>\n<h2 id=\"how-to-interpret-conditional-formatting-in-power-bi\">How to Interpret Conditional Formatting in Power BI?<\/h2>\n<p>Here, we will create the <a href=\"https:\/\/chartexpo.com\/blog\/sankey-diagram-in-power-bi\" target=\"_blank\" rel=\"noopener\">Sankey Diagram in Power BI<\/a> step by step.<\/p>\n<p><strong>Stage 1: Logging in to Power BI<\/strong><\/p>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email address and click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>You can choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<h4>Stage 2: Creating a Data Set and Selecting the Data Set to Use in Your Chart<\/h4>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/02\/select-paste-or-manually-enter-data-in-power-bi-ce487.jpg\" alt=\"select Paste or manually enter data in Power BI ce487\" width=\"650\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2NjkrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTY2OSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTY2OSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the <a href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\" target=\"_blank\" rel=\"noopener noreferrer\">sample data<\/a> below for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"68\"><strong>Total Cost<\/strong><\/td>\n<td width=\"99\"><strong>Company Type<\/strong><\/td>\n<td width=\"168\"><strong>Company Name<\/strong><\/td>\n<td width=\"153\"><strong>Expertise Categories<\/strong><\/td>\n<td width=\"132\"><strong>Expertise<\/strong><\/td>\n<td width=\"42\"><strong>Cost<\/strong><\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Skyline Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>15456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Skyline Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Mechanical Work<\/td>\n<td>10159<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Onyx General Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>18045<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Onyx General Contractors<\/td>\n<td>Mechanical Installation<\/td>\n<td>Mechanical Work<\/td>\n<td>12695<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Living Well Remodeling<\/td>\n<td>Mechanical Installation<\/td>\n<td>Plumbing &amp; Heating<\/td>\n<td>14589<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Subcontractor<\/td>\n<td>Living Well Remodeling<\/td>\n<td>Mechanical Installation<\/td>\n<td>Welding<\/td>\n<td>11456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Power-up Builders<\/td>\n<td>Raw Material<\/td>\n<td>Cement<\/td>\n<td>20561<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Power-up Builders<\/td>\n<td>Raw Material<\/td>\n<td>Steel<\/td>\n<td>32456<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Five-star Construction<\/td>\n<td>Raw Material<\/td>\n<td>Bricks<\/td>\n<td>10253<\/td>\n<\/tr>\n<tr>\n<td>Total Cost<\/td>\n<td>Supplier<\/td>\n<td>Five-star Construction<\/td>\n<td>Raw Material<\/td>\n<td>Timber<\/td>\n<td>9000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the data table above into the \u201cPower Query\u201d window. After that, select the \u201cCreate a dataset only\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-create-a-dataset-only-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-create-a-dataset-only-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Select Create a Dataset Only After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Navigate to the left-side menu, and click on the &#8220;Data Hub&#8221; option. Power BI will populate the data set list. If no data set has been created, you&#8217;ll get an error message.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/click-on-data-hub-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/click-on-data-hub-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Click on Data Hub After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Choose the preferred data set to be used in creating the <a href=\"https:\/\/chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey chart<\/a>. After that, Power BI will populate the screen as shown below:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/choose-preferred-data-set-in-creating-sankey-diagram-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/choose-preferred-data-set-in-creating-sankey-diagram-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Choose Preferred Data Set in Creating Sankey Diagram After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the \u201cCreate a report\u201d dropdown, and select \u201cStart from scratch.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/click-create-a-report-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/click-create-a-report-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Click Create a Report After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>A Report Canvas similar to the one below appears on your screen.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/report-canvas-to-one-below-appears-on-screen-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/report-canvas-to-one-below-appears-on-screen-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Report Canvas to One Below Appears on Screen After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<h4>Stage 3: Adding the Power BI Sankey Diagram Extension by ChartExpo<\/h4>\n<ul>\n<li>To create the Sankey Diagram, you\u2019ll need an add-in or Power BI visual from AppSource. Navigate to the right side of the Power BI dashboard and open the Power BI Visualizations panel. Click the ellipsis symbol (\u2026) to import the Power BI Sankey Diagram extension by ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/open-power-bi-visualizations-panel-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/open-power-bi-visualizations-panel-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Open Power BI Visualizations Panel After Doing Conditional Formatting in Power BI\" width=\"526\" \/><\/a><\/div>\n<ul>\n<li>Select the \u201cGet more visuals\u201d option from the menu that opens.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-get-more-visuals-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-get-more-visuals-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Select Get More Visuals After Doing Conditional Formatting in Power BI\" width=\"577\" \/><\/a><\/div>\n<ul>\n<li>Enter \u201cSankey Diagram for Power BI by ChartExpo\u201d in the highlighted search box. You\u2019ll see the \u201cSankey Diagram for Power BI by ChartExpo\u201d as shown in the image below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enter-sankey-diagram-for-power-bi-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enter-sankey-diagram-for-power-bi-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Enter Sankey Diagram for Power BI After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click on the highlighted \u201cAdd\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/click-add-button-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/click-add-button-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Click Add Button After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Power BI will add the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/sankey-diagram-icon-in-visualization-panel-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/sankey-diagram-icon-in-visualization-panel-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Sankey Diagram Icon in Visualization Panel After Doing Conditional Formatting in Power BI\" width=\"245\" \/><\/a><\/div>\n<h4>Stage 4: Drawing a Sankey Diagram with ChartExpo\u2019s Power BI extension.<\/h4>\n<ul>\n<li>Select the \u201cSankey Diagram for Power BI by ChartExpo\u201d icon in the visualization panel. A window similar to the one below will open in the report section of your dashboard.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/open-in-report-section-of-dashboard-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/open-in-report-section-of-dashboard-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Open in Report Section of Dashboard After Doing Conditional Formatting in Power BI\" width=\"389\" \/><\/a><\/div>\n<ul>\n<li>You can resize the visual as needed. Next, navigate to the right side of the Power BI dashboard. You\u2019ll see \u201cFields\u2019 next to \u201cVisualizations.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/you-will-see-fields-next-to-visualizations-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/you-will-see-fields-next-to-visualizations-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"You will See Fields Next to Visualizations After Doing Conditional Formatting in Power BI\" width=\"453\" \/><\/a><\/div>\n<ul>\n<li>At this point, you\u2019ll have to select the fields to use in the Sankey chart. To select the fields, follow the sequence below:\n<ul>\n<li>Total Cost<\/li>\n<li>Company Type<\/li>\n<li>Company Name<\/li>\n<li>Expertise Categories<\/li>\n<li>Expertise<\/li>\n<li>Cost<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-fields-follow-sequence-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-fields-follow-sequence-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Select Fields Follow Sequence After Doing Conditional Formatting in Power BI\" width=\"225\" \/><\/a><\/div>\n<ul>\n<li>You\u2019ll have to provide your email address or a ChartExpo license key.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enter-license-key-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enter-license-key-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Enter License Key After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<h4>Stage 5: Activate the ChartExpo Trial or Apply a Subscription Key<\/h4>\n<ul>\n<li>Select the ChartExpo visual. You\u2019ll see three icons below \u201cBuild Visual\u201d in the Visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/see-build-visual-in-visualization-panel-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/see-build-visual-in-visualization-panel-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"See Build Visual in Visualization Panel After Doing Conditional Formatting in Power BI\" width=\"260\" \/><\/a><\/div>\n<ul>\n<li>Select the middle icon, \u201cFormat visual.\u201d The visual properties will be populated as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-format-visual-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/select-format-visual-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Select Format Visual After Doing Conditional Formatting in Power BI\" width=\"236\" \/><\/a><\/div>\n<ul>\n<li>To use the ChartExpo as a new user, you\u2019ll have to enter your email address in the textbox under the \u201cTrial Mode\u201d section. The License key will be sent to your email address. To activate your 7-day trial, toggle \u201cEnable Trial.\u201d<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enable-trial-mode-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enable-trial-mode-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Enable Trial Mode After Doing Conditional Formatting in Power BI\" width=\"235\" \/><\/a><\/div>\n<ul>\n<li>You\u2019ll receive a welcome email from ChartExpo. The Sankey Diagram you create using the 7-day trial comes with the ChartExpo watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/you-see-sankey-diagram-with-chartexpo-watermark-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/you-see-sankey-diagram-with-chartexpo-watermark-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"You See Sankey Diagram with ChartExpo Watermark After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>If you have a license key, enter it in the \u201cChartExpo License Key&#8221; textbox in the &#8220;License Settings&#8221; section. Slide the toggle switch next to &#8220;Enable License&#8221; to &#8220;On.&#8221;<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enable-license-key-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/enable-license-key-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Enable License Key After Doing Conditional Formatting in Power BI\" width=\"233\" \/><\/a><\/div>\n<ul>\n<li>You\u2019ll notice that the Sankey diagram doesn\u2019t come with a watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/you-see-sankey-diagram-without-chartexpo-watermark-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/you-see-sankey-diagram-without-chartexpo-watermark-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"You See Sankey Diagram without ChartExpo Watermark After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Here\u2019s how to add a Prefix (like the $ sign) with the numeric values in the chart. Expand the \u201cStats\u201d properties and include the Prefix value.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/add-prefix-with-numeric-values-in-chart-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/add-prefix-with-numeric-values-in-chart-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Add Prefix with Numeric Values in Chart After Doing Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>To add colors to each node, expand the \u201cLevel Colors\u201d properties and select the colors.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/add-level-colors-and-select-colors-after-doing-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/add-level-colors-and-select-colors-after-doing-conditional-formatting-in-power-bi.jpg\" alt=\"Add Level Colors and Select Colors After Doing Conditional Formatting in Power BI\" width=\"220\" \/><\/a><\/div>\n<ul>\n<li>All changes will be automatically saved.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/final-conditional-formatting-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/final-conditional-formatting-in-power-bi.jpg\" alt=\"Final Conditional Formatting in Power BI\" width=\"650\" \/><\/a><\/div>\n<p>&nbsp;<\/p>\n<p><strong>Insights<\/strong><\/p>\n<ul>\n<li>At Level 1 (Total Cost), the procurement cost is $155K.<\/li>\n<li>At Level 2 (Company Type), out of the $155K cost, $82.4K (53.3%) was spent on subcontractors, while $72.3K (46.7%) was allocated to the supplier.<\/li>\n<li>At Level 3 (Company Name), the supplier cost of $72.3K was divided between two companies: Five-star Construction and Power-up Builder, with charges of $19.3K and $53.0K, respectively.<\/li>\n<li>The subcontractor cost of $82.4K was distributed among three companies: Onyx General Contractors, Skyline Contractors, and Living Well Remodeling. They charged $30.7K, $25.6K, and $26.0K, respectively, for their services..<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk2NjkrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTY2OSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTY2OSs=\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h2 id=\"how-to-remove-power-bi-conditional-formatting\">How to Remove Power BI Conditional Formatting?<\/h2>\n<ol>\n<li><strong data-start=\"467\" data-end=\"493\">Select your visual:<\/strong> Click the table or matrix visual that contains conditional formatting.<\/li>\n<li><strong data-start=\"572\" data-end=\"603\">Open formatting options:<\/strong> In the Visualizations pane, go to the Values section and locate the formatted field.<\/li>\n<li><strong data-start=\"700\" data-end=\"742\">Access the Conditional formatting menu:<\/strong> Click the down arrow next to the field name and hover over Conditional formatting.<\/li>\n<li><strong data-start=\"837\" data-end=\"866\">Remove the formatting:<\/strong> Select the formatting type you want to clear, such as Remove background color, Remove font color, or Remove icons.<\/li>\n<li><strong data-start=\"997\" data-end=\"1023\">Review your visual:<\/strong> Check the table or matrix to confirm that the conditional formatting has been successfully removed.<\/li>\n<\/ol>\n<h2 id=\"benefits-of-using-power-bi-conditional-formatting-function\">Benefits of Using Power BI Conditional Formatting Function<\/h2>\n<ol>\n<li data-start=\"274\" data-end=\"441\"><strong data-start=\"274\" data-end=\"307\">Improved Data Interpretation: <\/strong>Makes it easier to understand complex data by visually emphasizing important values, patterns, and relationships in your reports.<\/li>\n<li data-start=\"443\" data-end=\"602\"><strong data-start=\"443\" data-end=\"472\">Enhanced Decision-Making: <\/strong>Enables users and stakeholders to quickly spot trends and variances, leading to faster and more confident business decisions.<\/li>\n<li data-start=\"604\" data-end=\"746\"><strong data-start=\"604\" data-end=\"623\">Visual Clarity: <\/strong>Adds visual cues such as color scales, icons, and data bars to make data more engaging and easier to read at a glance.<\/li>\n<li data-start=\"748\" data-end=\"912\"><strong data-start=\"748\" data-end=\"781\">Spotting Trends and Outliers: <\/strong>Automatically highlights patterns, anomalies, and significant data points that might otherwise go unnoticed in large datasets.<\/li>\n<li data-start=\"914\" data-end=\"1095\"><strong data-start=\"914\" data-end=\"943\">Highlighting Key Metrics: <\/strong>Draws attention to critical KPIs like performance against targets\u2014using color coding (for example, green for success and red for underperformance). When used with a <a href=\"https:\/\/chartexpo.com\/blog\/kpi-visual-in-power-bi\" target=\"_blank\" rel=\"noopener\">KPI visual in Power BI<\/a>, it becomes even easier to quickly interpret performance status and spot areas that need attention.<\/li>\n<\/ol>\n<h2 id=\"top-5-conditional-formatting-mistakes-in-power-bi\">Top 5 Conditional Formatting Mistakes in Power BI (and How to Fix Them)<\/h2>\n<ul>\n<li data-start=\"381\" data-end=\"604\"><strong data-start=\"381\" data-end=\"409\">Using Too Many Colors: <\/strong>Overloading visuals with colors can confuse viewers instead of guiding them.<\/li>\n<\/ul>\n<p data-start=\"381\" data-end=\"604\"><strong data-start=\"493\" data-end=\"501\">Fix:<\/strong> Stick to 2\u20133 main colors and use them consistently (for example, green for growth, red for decline).<\/p>\n<ul>\n<li data-start=\"606\" data-end=\"796\"><strong data-start=\"606\" data-end=\"634\">Ignoring Data Context: <\/strong>Applying one rule to all data types can lead to misleading results.<\/li>\n<\/ul>\n<p data-start=\"606\" data-end=\"796\"><strong data-start=\"709\" data-end=\"717\">Fix:<\/strong> Adjust your rules based on what each dataset represents and its value range.<\/p>\n<ul>\n<li data-start=\"798\" data-end=\"990\"><strong data-start=\"798\" data-end=\"826\">Relying Only on Color: <\/strong>Not everyone perceives colors the same way, especially color-blind users.<\/li>\n<\/ul>\n<p data-start=\"798\" data-end=\"990\"><strong data-start=\"907\" data-end=\"915\">Fix:<\/strong> Combine color with icons, data bars, or labels for better accessibility.<\/p>\n<ul>\n<li data-start=\"992\" data-end=\"1170\"><strong data-start=\"992\" data-end=\"1021\">Skipping Dynamic Logic: <\/strong>Static rules don\u2019t reflect changes in your data.<\/li>\n<\/ul>\n<p data-start=\"992\" data-end=\"1170\"><strong data-start=\"1077\" data-end=\"1085\">Fix:<\/strong> Use <strong data-start=\"1090\" data-end=\"1106\">DAX measures<\/strong> or field values to make your formatting update automatically.<\/p>\n<ul>\n<li data-start=\"1172\" data-end=\"1357\"><strong data-start=\"1172\" data-end=\"1201\">Overcomplicating Rules: <\/strong>Too many conditions can slow performance and make visuals messy.<\/li>\n<\/ul>\n<p data-start=\"1172\" data-end=\"1357\"><strong data-start=\"1273\" data-end=\"1281\">Fix:<\/strong> Keep your formatting simple and focus on highlighting what truly matters.<\/p>\n<h2 id=\"tips-for-advanced-conditional-formatting-in-power-bi\">Tips for Advanced Conditional Formatting in Power BI<\/h2>\n<ol>\n<li data-start=\"425\" data-end=\"619\"><strong data-start=\"425\" data-end=\"472\">Use DAX Measures for Dynamic Formatting: <\/strong>Create a DAX measure to control colors or styles based on complex logic. This allows your visuals to update automatically as data changes.<\/li>\n<li data-start=\"621\" data-end=\"819\"><strong data-start=\"621\" data-end=\"659\">Format Based on Another Column: <\/strong>Use values from a different field to drive conditional formatting. For example, base your sales color scale on profit margin rather than total revenue.<\/li>\n<li data-start=\"821\" data-end=\"1001\"><strong data-start=\"821\" data-end=\"847\">Add Dynamic Titles: <\/strong>Add conditional formatting in <a href=\"https:\/\/chartexpo.com\/tools\/power-bi-custom-visuals\" target=\"_blank\" rel=\"noopener\">Power BI charts<\/a> titles so they display information like the selected date range, product category, or performance summary.<\/li>\n<li data-start=\"1003\" data-end=\"1181\"><strong data-start=\"1003\" data-end=\"1034\">Customize Cell Elements: <\/strong>In tables and matrices, format specific cell elements\u2014such as background color, font color, data bars, or icons\u2014to highlight key insights.<\/li>\n<li data-start=\"1183\" data-end=\"1340\"><strong data-start=\"1183\" data-end=\"1224\">Combine Multiple Formatting Types: <\/strong>Mix background color, icons, and data bars together for richer visuals that show more context in a single view.<\/li>\n<\/ol>\n<h2 id=\"conditional-formatting-in-power-bi-faqs\">Conditional Formatting in Power BI &#8211; FAQs<\/h2>\n<h3>How do you add conditional formatting in Power BI measure?<\/h3>\n<p>To add conditional formatting in Power BI to a measure, select the measure, go to the \u201cFormat\u201d pane, navigate to \u201cConditional formatting,\u201d and configure rules for visual representation based on values.<\/p>\n<h3>How to do conditional formatting in DAX?<\/h3>\n<p>In DAX (Data Analysis Expressions), use the FORMAT function to add conditional formatting in Power BI. Within the function, define logical conditions to format measure outputs based on specified rules or criteria.<\/p>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Conditional formatting in Power BI allows users to visually enhance data representation by applying formatting rules based on values. It is crucial for highlighting patterns, anomalies, and trends. It also makes data interpretation more intuitive and facilitates informed decision-making.<\/p>\n<p>In Power BI, conditional formatting can be applied in color scales, data bars, icon sets, and rules-based formatting. Color scales can be used to assign different colors to data points based on their values. Data bars are horizontal bars that are added to a field to represent its value visually.<\/p>\n<p>Icon sets allow you to display icons (like flags, arrows, or traffic lights) next to the data points. Finally, rules-based formatting helps in defining custom rules to format data based on certain criteria.<\/p>\n<p>By following the steps outlined in this guide, you\u2019ll be able to create compelling visualizations while incorporating conditional formatting into the entire data analysis process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Learn how to use Conditional Formatting in Power BI to make your dashboards smarter, more colorful, and easier to interpret in just a few steps.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi\"><\/a><\/p>","protected":false},"author":1,"featured_media":43387,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Conditional Formatting in Power BI for Advanced Analytics -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Conditional Formatting in Power BI for Advanced Analytics -\" \/>\r\n<meta name=\"twitter:description\" content=\"Learn how to use Conditional Formatting in Power BI to make your dashboards smarter, more colorful, and easier to interpret in just a few steps.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/feature-ce669-200x200-1.jpg\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"20 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conditional Formatting in Power BI for Advanced Analytics -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi","twitter_card":"summary_large_image","twitter_title":"Conditional Formatting in Power BI for Advanced Analytics -","twitter_description":"Learn how to use Conditional Formatting in Power BI to make your dashboards smarter, more colorful, and easier to interpret in just a few steps.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2024\/10\/feature-ce669-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"20 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi","url":"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi","name":"Conditional Formatting in Power BI for Advanced Analytics -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2025-10-07T16:28:12+00:00","dateModified":"2026-04-17T17:57:45+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/conditional-formatting-in-power-bi#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Conditional Formatting in Power BI for Advanced Analytics"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/43376"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=43376"}],"version-history":[{"count":14,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/43376\/revisions"}],"predecessor-version":[{"id":60913,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/43376\/revisions\/60913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/43387"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=43376"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=43376"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=43376"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}