Power BI: where is the conditional formatting option in new format pane
Conditional formatting options have moved under different headings in the new format pane. This has been done to organize the information better. Please note that conditional formatting does not work with legend and more than one measure.
Table Visual → Under Cell Elements
Matrix Visual → Under Cell Elements
Stacked Bar Chart(When You are not using Legend) → Under Bars. Stacked has no meaning without legend, and fx will not be available once you use the legend
100% Stacked Bar Chart
Stacked Column Chart(When You are not using Legend) → Under Columns. Stacked has no meaning without legend, and fx will not be available once you use the legend
100% Column Bar Chart
Clustered Bar Visual → Under Bars
Clustered Column Visual → Under columns
Line → Line does not have it. Old trick: do it on bar convert to the line. Only colored markers.
Area →Area does not have it. Old trick: do it on bar convert to Area. Only colored markers. Stacked Area same way, if you are not using legend or more than one measure
Line and Stacked column chart. For Line, there is no conditional formatting option. For Column, we have unless we use the legend
Line and Clustered column chart. For Line, there is no conditional formatting option. For Column, we have unless we use the legend
Ribbon Visual → under Ribbons. Only with one measure and no legend.
Waterfall → No Option
Funnel → Under Color. Single Measure with Category
Scatter Visual → Under Markers
Pie/Donut → No Option. Old trick: do it on bar convert to Pie/Donut
Tree Map → Under Color
MAP → Under the bubble
Filled Map → Under Fill Color
Shape Map → Only Gradient
Gauge → under Color
Card → Under Callout value
Multi-Row Card → Under Callout values, Category Label, and cards
KPI → Under Trend Axis and Target Label
Refer to my Old Blog and video on conditional formatting: How to do conditional formatting by measure and apply it to pie
Click Here to access all my blogs and videos in a jiffy via an exclusive visual glossary using Power BI.
Please like, share, and comment on these. Your suggestions on improvement, challenges, and new topics will help me explore more.
You Can watch my Power BI Tutorial Series on My Channel, Subscribe, Like, and share
