cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NoMoreOQ99er Frequent Visitor
Frequent Visitor

Column Chart with Dynamically Colorable Columns and with Average and Limit Lines

I am searching for a column chart for Power BI for highlighting outliers in the data.  I'm needing for it to enable the following:

 

  1. Dynamic coloring of the columns, e.g. depending on whether the data point is within specified limits,
  2. Displaying of upper, lower, or both upper and lower limit lines, and
  3. Displaying of an average line--or better yet--a trend line.

We found one that allows dynamic coloring of the columns, but it's missing items 2 and 3.  Does anyone know if such a component exists?  Thank you.

 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Column Chart with Dynamically Colorable Columns and with Average and Limit Lines

Hi @NoMoreOQ99er,

 

#1. Power bi not support change columns color, maybe you can try to create table visual or matrix visual with 'conditional formatting' feature to setting color in visuals.

Conditional formatting in tables

 

#2. Please add calculated column or measure to use dax formula with UPPER, LOWER functions to convert characters case.

 

#3. These analytic lines are in analysis pane, please refer to below document to know how to use them.

Using the Analytics pane in Power BI Desktop

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
NoMoreOQ99er Frequent Visitor
Frequent Visitor

Re: Column Chart with Dynamically Colorable Columns and with Average and Limit Lines

Thanks.  We did try tabular format with conditional coloring, but the manager was hoping for a columnar display with conditional coloring, as it really shows where the bad data is and the limit lines show by how much.  Thanks.