MSBI Tutor

Power BI now supports conditional formatting for lines and legends across many visuals. You can apply gradients, rules, or field-driven colors to keep reports consistent, draw attention to important values, and reduce manual maintenance as data changes.   For charts with legends, you can define colors once in a measure or column and reuse them throughout a report. For line charts, you can format entire lines, individual segments, shading, markers, and series labels. This makes it easier to highlight the latest period, show increases and decreases, or emphasize specific data points dynamically. What is conditional formatting? Conditional formatting dynamically controls a visual property such as color, text, or a value. Depending on the setting, you can use: Rules based on numeric ranges, percentiles, or specific values and text. Gradients with minimum and maximum colors and an optional midpoint. Field values from a measure or column that returns a color or value. This option prov...

Open Power BI desktop and click on use sample data Click on Load Sample Data Click on check box beside financials data sheet. Click on load-to-load data to data model. Drag and drop table to canvas. Drag and drop required columns to table. Right click on any one of column in build tab and select conditional formatting as shown in bellow. Select conditional formatting as background color. Change format style as rules. Create rules as you required. Click on Ok. Font Color: Select conditional formatting as Font color. Change format style as rules. Create rules as you required. Click on OK. Data Bars: Select conditional formatting as Font color. Click on OK. Icons: Select conditional formatting as Icons. Select field as shown in bellow. Click on OK.